Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello,
I am trying to figure out a way to understand whether a user has selected all items on a slicer or no items at all.
If I use the formula
ISFILTERED( D_ProductionLinesWithCC[ProductionLineCodeCC] )
it returns true if all items are sliced but 1. As soon as the user selects all items, it returns false as if none were selected.
Is there a way to tell whether the user is actively engaging with the slicer and selecting all items?
I am asking because I have a master slicer on top, and if I don't handle this, PowerBI considers that all items in the subslicer are selected if if the user has not touched them yet.
I am using the new button slicer visual.
Thanks!
Kind regards
Valeria
@ValeriaBreve You could do a COUNTROWS( 'Table' ) and an COUNTROWS( ALL( 'Table' ) ). If they are equal to one another then all items have been selected.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 13 | |
| 8 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 29 | |
| 19 | |
| 18 | |
| 11 | |
| 10 |