Permanent Slicer

[jcarville]

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.

[Greg_Deckler]

No, you would probably want to use a page or report level filter in this case.

[fbrossard]

Hi @jcarville

Just save your report with the desired values selected.

[jcarville]

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.

[konstantinos · Accepted solution]

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

[MarcNavarro]

@konstantinos I don't understand how to use your code to "blank" visuals if anything is selected, do you have any example?

Thanks!

[jcarville]

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.