Restrict Slicer selection count to 2

[Nareshbaabu]

Hi All,

How do we restrict Slicer selection count to 2 . Instead of multiple selection. Can we restrict it to 2 Counts?

[Abduvali]

@Nareshbaabu,

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

[Nareshbaabu]

@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.

[v-yulgu-msft]

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

[Nareshbaabu · Accepted solution]

@v-yulgu-msft

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 

[uqmpasha]

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

[Abduvali]

Hi, Working fine for me, just use Filter on the actual visual. See attached screenshot:

Please marked solved if it helped.

Regards

Abduvali