Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
Hi Champions
I have this visualisation in PB:
Want to calulate % of each column for each country and show it under total in the matrix table. Can anyone assist me : something like below:
Thanks
Thanks Vicky, I couldn'y figure out with your solution. I am looking for someting like this (Red Circle)
Are you using implicit measures? if so then there an option to show subtotals %
If you only need the value to show in the totals row, then the solution might be a bit more complicated. I would use a measure instead, and do something like:
Measure = IF(HASONEVALUE(Table[Country]),
// your existing calculation here
// else DIVIDE(your calculation, CALCULATE(your calculation, removefilters(Table[Country]))
)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
78 | |
40 | |
40 | |
35 |