Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Avivek
Post Partisan
Post Partisan

Need help with matrix visual formatting

I have a matrix table and I do not want subtotals for the columns, I only need overall total

Avivek_0-1659706139769.png

The one marked in red, those totals I do not want them to be there on the visual but if I toggle off the column subtotal then the Proc total and Average in blue colour in the right end also gets removed.

Also Proc Total should only have Y N and Totl of Procedure beneath it, similarly for Average.

 

Does anyone have a clue how to format them.

 

1 ACCEPTED SOLUTION
PaulDBrown
Community Champion
Community Champion

The easiest way is to turn off "word wrap" (do a search in the cormatting pane) and then drag the column right column boundaries left to hide the rogue columns





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

2 REPLIES 2
PaulDBrown
Community Champion
Community Champion

The easiest way is to turn off "word wrap" (do a search in the cormatting pane) and then drag the column right column boundaries left to hide the rogue columns





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Hi thats what I have done, I was just wondering if there is any other way to avoid this.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.