Forum Discussion
Permanent Slicer
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
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
Hi konstantinos, I got it working. As you say not optimal and it is a complete workaround but at least it could be something to show the user.
If no other suggestions arrive I will accept this as the solution. Many thanks guys.