Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
This is a strange bug. I get the same outcome using Power BI Desktop and the Power BI Service. In the below screenshot, I have duplicated a Matrix such that the only difference is the highlighted toggle. As you can see in the bottom matrix, the values in the bottom matrix are incorrect. They are the values from the top matrix, transposed in the same column coordinates.
That being, the top matrix has 7 columns. The bottom has 4 columns. The bottom's values are columns 1 to 4 from the top Matrix, instead of being columns 1, 3, 5, 7.
The issue is not present when the Columns are collapsed up (second screenshot). I can remove either column's field and see the correct result.
I have tried to reproduce the issue in a small example file, but could not get the same issue. This suggests that this only occurs when the complexity of the model & measures grow. (Third Screenshot)
2nd Screenshot
3rd Screenshot
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @RossEdwards
Currently our Desktop has been updated to 2.128.1380.0 64-bit (April 2024), you can test on this version . Since the fix for the problem will only be fixed on the new version, PG will still let you update to the latest version to test it if you're having problems with an older version.
Download Microsoft Power BI Desktop from Official Microsoft Download Center
If the problem still exists, I suggest you can raise a Support Ticket . A dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.
The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/
For how to create a support ticket, please refer to https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...
Best Regards,
Community Support Team _ Ailsa Tao