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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Slicer on Subtotals row of Matrix Visualization

Hi All,

I am working to include slicers on subtotals rows of Matrix Visluization:

 

P.S: I have build matrix as a pivot in excel so it has subrows too which contribute to the count of subtotals.

 

Below is the screenshot. I want to put slicer on yellow highlighted numbers:

 

Note: I tried to add the slicer on summation column however it filters based on sub rows values also (and I want only on subtotalsCapture.JPG

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous ,

I'd like to suggest you unrelated table fields as source of slicer, then write a measure to check current row contents level and compare with selected value.

Measure Totals, The Final Word

Understanding DAX Auto-Exist

Clever Hierarchy Handling in DAX

Regards,

Xiaoxin Sheng

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @Anonymous ,

I'd like to suggest you unrelated table fields as source of slicer, then write a measure to check current row contents level and compare with selected value.

Measure Totals, The Final Word

Understanding DAX Auto-Exist

Clever Hierarchy Handling in DAX

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.