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
shashank's avatar
shashank
Helper III
9 years ago

Hi Angelina,

 

thanks for your reply, my question was in context of any type of filter be it normal filter in power bi or slicer..i want to resetrict to user that they are able to choose only one value at any point of time.

 

i observe that if user does not select any single item then it become "All" but i want that user must select one and only one any value , is there any work around ?

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi shashank,

When user select nothing, you want it shows nothing. Otherwise, the user only select one value and display the corresponding results? If my understanding is right, it's impossible to display nothing when no value is selected. When no value is selected, it shows "All" values. The slicer is used to filter rows in Power BI desktop.

Best Regards,
Angelia

  • shashank's avatar
    shashank
    Helper III
    9 years ago

    Hi,

     

    i'm not talking specifically about slicer , i'm talking about normal filter.

     

    i want user to resetric that user always select one and only one value.

     

    Niether "ALL" nor "Nothing"

     

    hope it's clear.

    • shashank's avatar
      shashank
      Helper III
      9 years ago

      Hello everyone,

       

      i'm still waiting for any convining reply on that either "Yes" or "No" or any other work around of that ?

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        9 years ago

        Hi shashank,

        Until now, we can not set the slicer feature by ourselves. The use can choose one or mutiple values in slicer. When no value is selected, the report shows all values.

        Best Regards,
        Angelia