Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi,
I have the scenario to choose the slicer not more than two selection at a time.
Is this possible? In what way?
Solved! Go to Solution.
@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",
""
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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",
""
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Umadhandapani I am not sure about DAX measure, but you can use the custom visual to control the selection limit
@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?
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 55 | |
| 49 | |
| 33 | |
| 16 | |
| 15 |
| User | Count |
|---|---|
| 85 | |
| 70 | |
| 38 | |
| 28 | |
| 25 |