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
I followed the solution by Waltheed for adding % of total but hiding it for each column and leaving only the % of total column at the end. What I'm left with, however, is the word "total" under each column. Does anyone know of a workaround for this? I tried selecting each column and leaving label blank but wasn't an option.
Hi @Kds1113
Can you try turning of the column sub totals?
It could also be that you have to do it on a specidfic column level
It is a best gues but maybe it helps. 🙂
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
@Mikelytics thanks for the suggestions but neither works. They both remove only the last 2 columns (Total/Total & %CT Total).
Fore reference, I have additional columns in my matrix that are not shown in the screenshot.
Rows: Expense Type, Category
Columns: Items (the 5 columns shown in the screenshot with the Total label beneath them)
Values: Total (this is a measure), %CT Total (this displays Total as a % of Total per Waltheed's advice)
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |