How to choose different saved search in a single panel based on drop down selection type in kibana dashboard

I have use case where based on TransactionType(dropdown), I need to execute different searches in the visualisation dashboard.

Example:
PO - I have created a search where i have to group the events by OrderNumber
ASN - I have created a search where i have to group the events by SalesOrderNumber, ShipmentNumber (since one order may have multiple shipments)
Invoice - I have created a search where i have to group the events by InvoiceNumber

To solve this, I have created individual saved searches and added them to the dashboard by including them from the library. Currently, I have three separate panels that display data based on the selection from a TransactionType dropdown. However, only the panel corresponding to the selected dropdown option is populated, while the other two panels remain empty, which leads to a poor user experience.

I am looking for a way to ensure that only one panel is displayed at a time based on the dropdown selection, with the relevant saved search being invoked dynamically. Any suggestions or ideas to improve this functionality would be greatly appreciated. Thank you.

Hi @halex , welcome to our commuinty.

Have you checked the option to create drilldowns? Using Dashboard Drilldowns with Lens visualizations could ensure that only the relevant visualization is displayed based on the dropdown selection.

Dashboard Drilldowns Documentation

Best,

Thank you @Alex_Salgado-Elastic.

The transaction type is a control I have added.

But I have 5 saved search defined. when I select PO as transaction type its loading PO saved search and other panels (saved searches ) are empty.