Matrix visual no longer filtering based on page and slicer values

[Sarah_Lanning]

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

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

[Sarah_Lanning · Accepted solution]

Dashfund is the common dimension among all related tables and is used for joins and filters in both directions, allowing the slicer to affect the visual.  And again, all was working until recently.

[v-ssriganesh]

Hi @Sarah_Lanning,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-ssriganesh]

Hi @Sarah_Lanning,

May I ask if you have resolved this issue? If so, please mark it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[amitchandak]

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

[Sarah_Lanning · Accepted solution]

Dashfund is the common dimension among all related tables and is used for joins and filters in both directions, allowing the slicer to affect the visual.  And again, all was working until recently.

[v-ssriganesh · Accepted solution]

Hello @Sarah_Lanning,
Thank you for reaching out to the Microsoft Fabric Forum Community.

To make your visual respond dynamically to slicers, consider one of the following:

• Use measures instead of a calculated table and build your matrix directly off the Budget table. Create measures that summarize values as needed using CALCULATE, SUMX, or SUMMARIZE logic within the measure these do respond to slicers.
• Use a calculated table only as a source for disconnected slicers or static visuals, not interactive ones.

Let me know if you’d like help converting your BudgetPivot logic into dynamic measures for the matrix visual.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[v-ssriganesh]

Hi @Sarah_Lanning,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.