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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Sarah_Lanning
New Member

Matrix visual no longer filtering based on page and slicer values

I have a matrix visual that uses a data table built with a SummarizeColumns command. 

 

 

 

BudgetPivot = 
SummarizeColumns('Budget'[Budget Line],'Budget'[Funding Category],'Budget'[FY],'Budget'[SlotConv],'Budget'[Dashboard],'Budget'[Funding],'Budget'[IT Category],'Budget'[Contract Name],'Budget'[DashFund],'Budget'[Cost],'Budget'[Time Category])

 

 

 

 

The filter icon for the visual shows it is filtered using a combination of page filters, slicers, and filters set on the visual itself, and if I look at the data table directly and filter by those filters, the data is correct.  However, when I look at the visual, the second-level rows within the visual are not filtered by anything except the filters applied to the visual itself.  It is ignoring the page and slicer filters.  I've checked to confirm that the visual is set to "keep all filters" and that the slicer interactions do include that visual.  This all worked a few weeks ago.  I've been on vacation, so I'm not sure exactly when it stopped working, but I haven't made any changes, and now it doesn't work.  This image shows the visual without the correct filtering on top, and on bottom it shows what it would look like if the filters were filtering correctly.  Note that the list of filters and slicers affecting the visual lists all the filters, so they are supposed to be getting applied, but they are not. (I put the relevant filters on the bottom visual directly to make them work so I could show what it should be; otherwise, that visual doesn't filter correctly either.)

Screenshot 2025-03-12 142106.png

 

 

@Microsoft I think this might be a bug, and I tried to submit a support ticket, but I don't see how to submit one for PowerBI - the page to submit tickets in Fabric didn't list Power BI in the required field dropdown list of products.

1 REPLY 1
amitchandak
Super User
Super User

@Sarah_Lanning , if you have created a calculated table using DAX, then it will not take any filter of slicer values. It needs to be joined back with common dimension to filter the values.

calculated table and columns are static in nature and do changes with filter and slicer values (In Data table)

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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