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! It's time to submit your entry. Live now!
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! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 56 | |
| 41 | |
| 39 | |
| 22 | |
| 21 |
| User | Count |
|---|---|
| 144 | |
| 106 | |
| 63 | |
| 38 | |
| 31 |