Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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]))
)
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 36 | |
| 28 | |
| 28 |
| User | Count |
|---|---|
| 124 | |
| 88 | |
| 74 | |
| 66 | |
| 65 |