Desktop

[Nareshbaabu]

Hi All,

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

[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 

[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 

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