Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi there!
Odd one with a Matrix visual using a hierarchy I have created.
If I drill up or drill down my column hierarchy (to view one level at a time) the numbers in the Matrix are correct. But as soon as I expand to the next level (to see both levels of the hierarchy), the numbers switch to adding up cumulatively regardless of the column in the visual:
The relationships are fairly simple (I think): One descriptor can have multiple bands, each band can have multiple scores. I have taken this approach because I need to include a table with arbritrary numbers in from another source (the national data):
Is this a relationship problem?
Thanks in anticipation!
Noted. It will take me a bit of time to do this, I'll work on it at the weekend and reply next week.
Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |