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

ADX user123 0 Reputation points
2024-06-24T08:22:35.46+00:00

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 !

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 83,891 Reputation points Microsoft Employee
    2024-06-24T11:01:46.34+00:00

    @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")

    User's image

    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")

    User's image

    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.