Forum Discussion

MatthijsOFG's avatar
MatthijsOFG
Frequent Visitor
9 months ago
Solved

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

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

    • MatthijsOFG's avatar
      MatthijsOFG
      Frequent 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.

      • v-menakakota's avatar
        v-menakakota
        Community 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