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
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi shashank,

Your filter means the slicer? If it is, you want to let user only select the single value as well as can't select multiple values at once? Actually, we select one value once in slicer by default. Only you select CTRL, you can select multiple values.

Best Regards,
Angelia

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 ?