- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Restrict Slicer selection count to 2
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-22-2017 02:25 AM - edited 11-22-2017 02:25 AM
Hi All,
How do we restrict Slicer selection count to 2 . Instead of multiple selection. Can we restrict it to 2 Counts?
Solved! Go to Solution.
Accepted Solutions
Re: Restrict Slicer selection count to 2
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-23-2017 03:42 AM
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
All Replies
Re: Restrict Slicer selection count to 2
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-22-2017 06:40 PM
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Re: Restrict Slicer selection count to 2
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-23-2017 03:42 AM
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
Re: Restrict Slicer selection count to 2
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-23-2017 03:57 AM
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
Re: Restrict Slicer selection count to 2
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-08-2017 02:28 AM
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.