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
Thanks fbrossard, I understand that, but what I really want is for a user to not be able to select no value, i.e. one value must always be selected at all times.
If the user has not got an option selected on the slicer then everything will show on my page which makes it cluttered.
I know I could just tell the user to always have an option selected on the slicer but I would like to ensure they do that.
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.
konstantinos I don't understand how to use your code to "blank" visuals if anything is selected, do you have any example?
Thanks!
