When a slicer value is selected hide the slicer

[vilenm]

Hi

I am trying to improve user experience by trying to make less clicks for users.

I have a bookmark that shows and hides a filter. However, is there a way for the slicer or shape to dynamically hide as soon as any filter value is selected ?

[amitchandak · Accepted solution]

@vilenm , there few things like using transparent color with isfiltered. use on text, background font etc

if(isfiltered(Table[Column]), "#FFFFFF00", "#000000")

or

if(not isfiltered(Table[Column]), "#FFFFFF00", "#000000")