Forum Discussion
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
6 Replies
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
- No, you would probably want to use a page or report level filter in this case.
