Forum Discussion
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
6 Replies
Hi Nareshbaabu,
No. Currently, it is not possible to restrict the slicer selection count to a specific number. It only supports single selection and multiple selection.
Regards,
Yuliana Gu
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
Hi,
I am a newbee! I have added smart filter by OKVIZ but have not found any option that helps me to restrict the selection. Am I missing anything?
Best,
Mos
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.
- Say you have departments but you only want to see HR and Sales in a filter
