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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
ValeriaBreve
Post Partisan
Post Partisan

Understanding if the user has selected all options on a slicer

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

 

1 REPLY 1
GeraldGEmerick
Memorable Member
Memorable Member

@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.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.