Forum Discussion
Matrix behaviour multiple parameters
Hello,
For a financial report i have a matrix setup with level 1, 2 and 3 that refer to the group level of the general ledger accounts. Instead of directly having the ledger group columns in the matrix, I have 3 parameters each with 3 options A, B and C. This refers to whether or not the company selection is a consolidation level. For every ledger account there are 9 groups 1A to C3. For example the ledger accounts sales intercompany has group 1A=sales but group 1C = elimination.
It worked fine until the July update. The problem now is that when I deselect the company and select a company on another consolidation option, it somehow goes down in the level.
1. I select a company in A and my matrix is on level 1A.
2. I deselect the company in A and select the company in C, I expect the matrix to open on 1C. However it opens on 2C or 3C.
Users now have to know about drilling up, which most don't. Does anyone know a solution to this issue?
link to small video of issue: https://imgur.com/a/matrix-issue-gKJDPrE
I think it's related to this issue:
https://www.reddit.com/r/PowerBI/comments/1mk8n7v/july_2025_matrix_behavior_change_field_parameters/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button
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.
14 Replies
- MFelixSuper User
Hi MatthijsOFG ,
Without further information is difficult to pinpoint the error, specially when you refer that this was working until the July update, there were some changes.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.- MatthijsOFGFrequent Visitor
Hi Miguel Félix, thanks for your message. It is sensitive data, so I will try to recreate the issue with some mockup data.
- MatthijsOFGFrequent Visitor
link to mockup data: https://we.tl/t-mTdIchkM8X
- v-menakakotaCommunity Support
Hi MatthijsOFG ,
Thanks for reaching out to the Microsoft fabric community forum.
When I tried to open the sample file, it displayed as shown below. Could you please review the data and provide the correct data.
Best Regards,
Community Support Team