Skip to main content
Question

Avoiding Deselection/Errors when creating Dynamic filters with Drop-Down menu

  • June 22, 2023
  • 3 replies
  • 12 views

Hi Everyone,

I have the following situation and problem:

 

I created a variable, based on a "Store"-Table used to dynamically filter dashboards and analysis. The stores-variable is loaded from a table as a "text/replacement"-variable.

 

I used a dropdown-menu to select certain stores. The analysis are then filtered by this selection. So, when you select "Store A" and "Store C" but leave out Store B you only get to see data from those two stores, but not Store B.

 

Here is the problem:

 

When I then want to reselect "Store B" the field to do so is greyed out. Furthermore if I deselct every Store the dropdown-menu is completly empty. I can no longer reselect any. It is as if the menu has forgotten these entries ever existed.

 

So:

How i build a dropdown menu to dynamically filter analysis and select/deselect and reselect any attributes?

 

Thanks for your help in advance!

3 replies

  • June 22, 2023

Hi Johannes,

 

it could be that you use the filter (with the variable) on the Sheet Level, if so try to click on the dropdown (Edit Modus) and there is a field "Component is not filtered with selections" that you need to check it


  • Author
  • Level 1
  • June 22, 2023

Hi Rashid,

that worked perfectly! Thanks for the answer!


  • June 22, 2023

Hi Rashid,

that worked perfectly! Thanks for the answer!

you are welcome :)