Forum Discussion

shashank's avatar
shashank
Helper III
9 years ago

Compulsory single select in filter

Hi Team,   just wanted to check can we make sure some how that user select single value(it's must that user should always select some value) in filter ?
Need Help
Show and Tell
Tips and Tricks
zsloane's avatar
zsloane
Frequent Visitor
7 years ago

I have a similar use case. My workaround is to use wrapper measures on the report page that require a single selection in a slicer before they will calculate anything. You can test for the single selection using the HASONEFILTER() function against the field used in the slicer. If FALSE, the measure can then return BLANK() or some text message for the user (if the visual can display text).

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello,

     

    There is no option to disable "Select all" or to have a force selection in a slicer. But i have developed a workaround to hide all the data. Create 2 measures as below. (similar solution as mentioned by zsloane.)

     

    Valid_selection = if(HASONEVALUE(Slicer_attribute), "", "Error: Select a Single value")

    Valid_selection_numeric = if(HASONEVALUE(Slicer_attribute), 1, 0)

     

    Pull the first measure into a card, which will be blank when a single value is selected and will throw an error message when it is more than one/All.

     

    Second measure to be added as a visual level filter, add Valid_selection_numeric = 1 as visual level filter on all the visuals. Which means, the data will be displayed only when a single value is selected. 

    Nothing but hiding the data for all.

     

    Let me know if you have any questions.

     

    Hope this helps.