Forum Discussion
shashank
9 years agoHelper III
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 ?
shashank
9 years agoHelper III
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
9 years agoMicrosoft Employee
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