Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Default slicer - based on some condition

Hello Team,   I am working on a requirement to have slicer (filter) in the dashboard, consider the columns name as BASELINE used in my slicer. Now i wanted to show all the values in the BASELINE co...
Need Help
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
3 years ago

Hey Anonymous ,

 

at the current moment it is not possible to define a value for a slicer.

Often this is implemented by creating a 2nd slicer containing only two values like ALL and DEFAULT.
Then you can create a measure that helps to hide or show the values from the basic slicer.

How to show or hide values from a slicer is described in greater detail in this article: https://www.sqlbi.com/articles/syncing-slicers-in-power-bi/

 

Hopefully, this provides you with an idea of how to tackle your challenge.

 

Regards,

Tom