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
North2Alaska
New Member

Chicklet Slicer

I'm using the Chicklet Slicer to filter a set of data.  There are other slicers that affect the number of rows contained in the Chicklet.  What I'm trying to do its work out how to report the number of rows in the Chicklet so I can display it.  

 

Thanks for any help.

1 ACCEPTED SOLUTION

@North2Alaska ahh try this measure

 

Count Rows without Name Filter = 
Measure = CALCULATE( COUNTROWS ( 'Table' ), ALL ('Table'[Name] ) )

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

4 REPLIES 4
parry2k
Super User
Super User

@North2Alaska I guess you are trying to set rows dynamically in chicklet slicer, correct? I dont think that is possible, I could be wrong.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Well not quite.  I have a table of collection with columns Name(and it is unique), Type as well as others.  The Chicklet is the list of names and it is sent to require one to be selected so the table visualization is filtered for that one row.  With another slicer on Type, the number of items in the Chicklet is reduced. When I get a count (and I've tried several ways) I either get 1 or 256 as the totall number of rows.  What I want is the number of rows displayed by the Chicklet.  

 

Another way to look at it is I want to count the number of rows filtered without the name filtered applied, even though it is.

@North2Alaska ahh try this measure

 

Count Rows without Name Filter = 
Measure = CALCULATE( COUNTROWS ( 'Table' ), ALL ('Table'[Name] ) )

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Perfect!  That worked.  🙂

Seems simple with the answer, but I just couldn't wrap my head around it...

 

Thank you for the help....

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.