Reply
Frequent Visitor
Posts: 17
Registered: ‎08-01-2017
Accepted Solution

Restrict Slicer selection count to 2

[ Edited ]

Hi All,

 

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


Accepted Solutions
Highlighted
Frequent Visitor
Posts: 17
Registered: ‎08-01-2017

Re: Restrict Slicer selection count to 2

@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 

View solution in original post


All Replies
Community Support Team
Posts: 5,709
Registered: ‎09-21-2016

Re: Restrict Slicer selection count to 2

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor
Posts: 17
Registered: ‎08-01-2017

Re: Restrict Slicer selection count to 2

@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 

Established Member
Posts: 185
Registered: ‎11-15-2016

Re: Restrict Slicer selection count to 2

@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

 

Frequent Visitor
Posts: 17
Registered: ‎08-01-2017

Re: Restrict Slicer selection count to 2

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