Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good Morning all... hope you are doing good
I have this simple report
The first object is simple treemap
The second one is a matrix. The value of the matrix is the following measure shows as % of Column Total,
BUDGET % = DIVIDE(CALCULATE(SUM('Rd''H Budget'[BUDGET])),
CALCULATE(SUM('Rd''H Budget'[BUDGET]),
ALLEXCEPT('Rd''H Budget','Rd''H Budget'[EXERCICE FISCALE 2]))
)
What I want to do is: when I select an element of the treemap, the matrix should display the percentage of the element.
Right now, when I select an element, this is what happens, the matrix displays 100%
How to get the matrix to display the value as % of Column Total (Colum total: considering all the value in the treemap, not the selected one). Other said I want the value of the matrix to not change to 100%, but to still show the original value when none of the element in the treemap was selected.
Thank you for your help and your understanding!
Regards,
Hi @Hey,
Could you post your table structures with some sample data which can help us to reproduce this issue? So that we can better assist on it. It's better to share a sample pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |