Indicate that slicers are applied, when the slicer pane is closed

[Jo_Swinnen]

Hi all,

we are creating a report where the slicers are only visible when you click on a filter button. In this filter pane we have a table which shows which filters are applied and all the slicers you can apply.

Example filter pane: 

Now we are looking for a way to indicate that slicers are applied when the filter pane is closed, for instance a green circle in front of the filter button. In this way the user is aware that slicers are applied. For instance: 

Does anyone have any ideas? 

Thanks,

Jo 

[Jo_Swinnen]

Hi, I've made indeed a circle with the following DAX-code:

Filter_on = IF(

    ISFILTERED('Dim Age'[Leeftijdsgroep 5 jaar])||

    ISFILTERED('Dim Age'[Classe d'âge 5 ans])   

,

    "#F56600", "#FFFFFF00" )

[pceglie · Accepted solution]

Hi, trivially you could insert a shape (overlaid on the filter icon) and use "conditional formatting" on the color property by evaluating an an appropriate measure that verifies if filters are applied or not.

Hope will help

--

PC