Forum Discussion
Matrix behaviour multiple parameters
- 8 months ago
Hi MatthijsOFG ,
Based on the July 2025 update, this behavior is a known change related to how the matrix now retains the drill level when switching field parameter values.
At the moment, there isn’t a direct fix available from the product side. As the MFelix mentioned, please refer to the blog post and CAT team comments shared earlierthey explain the change and current limitations.
I would also take a moment to thank MFelix , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
Thank you.
Okay now I'm even more confused because you seem to be doing the same thing as me with a different result. This is what I am seeing: https://imgur.com/a/v2LwtQH
To be clear, if you click directly from company to company or consolidation it works fine. The problem only occurs when you first deselect, and then select a new option. Could you try to do this sequence:
1. select companyA on level 1A
2. deselect companyA
3. select consolidationB
4. deselect consolidationB
5. select consolidationC
That causes the issue 100% of the times for me.
Hi MatthijsOFG ,
To assist you further, could you please provide sample data that clearly illustrates the issue you're experiencing?
- Include a small dataset that fully captures the issue (preferably in table format or as a downloadable file, not just a screenshot).
- Avoid including any sensitive or unrelated information.
- Also share the expected outcome based on the sample data you provide.
Need help preparing or uploading sample data? You can refer to this helpful guide:
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
This will help us reproduce your scenario accurately and provide a precise solution.
Best regards,
Community Support Team
- MatthijsOFG9 months agoFrequent Visitor
Hi,
You should be able to download the pbix file here: https://we.tl/t-DiqjC6vd3A
You will see a slicer and a matrix. Company C is selected and the matrix is on level 1A.
Please follow these steps in the slicer:
1. deselect companyC
2. select consolidationB
3. deselect consolidationB
4. select consolidationC
I would expect the matrix to be on level 1C after these steps. However, it moves down a level to 2c. Why does this happen? The users of my reports now have to manually drill up after changing slicer selection.