Forum Discussion
Solved
Restrict Slicer selection count to 2
Hi All, How do we restrict Slicer selection count to 2 . Instead of multiple selection. Can we restrict it to 2 Counts?
Default slicer don't have that capability. I've found the custom visual. It's able to restrict selection count to our required number.
Smart Filter by OKViz
You can do it but you have to create a new column with only those 2 selections something like this:
- Say you have departments but you only want to see HR and Sales in a filter
- Column = if(Table1[Department]="HR", "HR",if(Table1[Department]="Sales","Sales",Blank())
Hope this helps.
Regards
Abduvali
Instead of specifying HR and sales by default, I need to select it in run time. By default Power BI doesn't support that feauture.
See my early response. We can acheive it by using custom visual.