How to pass multiple values to parameter at once in Azure Data Explorer dashboard

Question

I want to search for multiple values . For example 10 - 15 values at once

I cannot use "Multiple Selection parameter " as it impacts performance, time to run a initial all values query and then manually searching and selecting required value in parameter box.

I tried to use "Free text parameter", however it is working only with one value at once.

How can I pass multiple search values at once which satisfies below command in StormEvents table

| where State in ("FLORIDA", "ATLANTIC SOUTH", "CALIFORNIA", "NEW MEXICO", "ARIZONA", "AMERICAN SAMOA", "KENTUCKY", "KANSAS", "MARYLAND", "PENNSYLVANIA", "ALABAMA", "MISSISSIPPI", "MICHIGAN", "OHIO", "GEORGIA")

Need solution urgently please,

Thank you !

Answer 1

@ADX user123 - Thanks for the question and using MS Q&A platform.

To pass multiple search values at once in Azure Data Explorer dashboard, you can use the "Multi-value parameter" option. However, as you mentioned, it may impact performance if you have a large number of values.

Now, you can use the following query to filter the "StormEvents" table based on the values entered in the "Filter" parameter:

StormEvents
| where State in ({Filter})

When you run this query, it will replace the {Filter} placeholder with the values entered in the "Filter" parameter. For example, if you enter "FLORIDA, CALIFORNIA" in the "Filter" parameter, the query will be:

StormEvents
| where State in ("FLORIDA", "CALIFORNIA")

How can I pass multiple search values at once which satisfies below command in StormEvents table as shown below:

StormEvents
| where State in ("FLORIDA", "ATLANTIC SOUTH", "CALIFORNIA", "NEW MEXICO", "ARIZONA", "AMERICAN SAMOA", "KENTUCKY", "KANSAS", "MARYLAND", "PENNSYLVANIA", "ALABAMA", "MISSISSIPPI", "MICHIGAN", "OHIO", "GEORGIA")

For more details, refer to Kusto Query Language (KQL) overview.

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.