Forum Discussion

jcarville's avatar
jcarville
Skilled Sharer
10 years ago
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.
Need Help
  • konstantinos's avatar
    konstantinos
    10 years ago

    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

     

     

     

     

konstantinos's avatar
konstantinos
Memorable Member
10 years ago

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's avatar
MarcNavarro
Regular Visitor
10 years ago

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

 

Thanks!