Forum Discussion
Solved
Permanent Slicer
Hi guys, I had a search there of the forum and couldn't find what I'm looking for. Is there anyway to make at least one option of a slicer always be selected? Thanks.
Unfortunately there is an option like that..
You can try to adjust the slicer setting to hide "Select all" & also force to "Single Selection". Of course if he clicks again in the selected slicer it will unfilter all.
If you have a small number of measures in the report,( performance ) and you prefer instead of a cluttered report , a blank one so you can force user to select one try add in the measure IF( HASONEVALUE()...
Slicer column is the table name & name of the column used in slicer YourMeasure = [Total Sales] Show Blank = IF ( HASONEVALUE ( SlicerColumn ); [Total Sales] )
With the same formula you can return a text in a card that will prompt him to select
Show Message= IF ( NOT(HASONEVALUE ( SlicerColumn )); "i.e Select Client" )
This is not optimal but a workaround..Hope it helps
No, you would probably want to use a page or report level filter in this case.