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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

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
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.