Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Umadhandapani
Helper II
Helper II

Only two slicer selection at a time

Hi,

I have the scenario to choose the slicer not more than two selection at a time.
Is this possible? In what way?

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@Umadhandapani 

You can create a measure to show a text, sort of warning when users select more than 2 items from the slicer. This is the measure:

SelectionLimit = 
IF(
     ISCROSSFILTERED(financials[Product]) && COUNTROWS( VALUES( financials[Product] ) ) > 2 ,
     "Maximum 2 items",
     ""
)

Fowmy_0-1645423072138.png

 



Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

4 REPLIES 4
Fowmy
Super User
Super User

@Umadhandapani 

You can create a measure to show a text, sort of warning when users select more than 2 items from the slicer. This is the measure:

SelectionLimit = 
IF(
     ISCROSSFILTERED(financials[Product]) && COUNTROWS( VALUES( financials[Product] ) ) > 2 ,
     "Maximum 2 items",
     ""
)

Fowmy_0-1645423072138.png

 



Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

jaipal
Resolver III
Resolver III

@Umadhandapani  I am not sure about DAX measure, but you can use the custom visual to control the selection limit

jaipal_0-1645416614025.png

 

 

jaipal
Resolver III
Resolver III

@Umadhandapani  as far as I know either you can set to single selection or multi selection. I don't think there is an option to set selection limit. 

 

FYI: I hope you already know you can multi select by holding "ctrl"

Is there any other visual to use the concept?
Or using any measures?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.