Skip to main content

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!

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


Hi Rashid,

that worked perfectly! Thanks for the answer!


Hi Rashid,

that worked perfectly! Thanks for the answer!

you are welcome :)


Reply