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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
louisvp
Helper II
Helper II

Is it possible to change the names of the subtotal and total in the Table Matrix?

Dear Community,
@amitchandak 
If have created a structure of cost types to use in a Matrix visual in Power BI.

No wI want to change the names of the subtotal and total in the Table Matrix.

 

1. Is this possible like in the picture below

 

2. Is it also possible to choice which subtotal you want to show? Like in the picture below?

 

Is there a custom visual available which can do this? Becasue the dfault matrix visual is not able to do these 2 things

louisvp_0-1607435908452.png

Kind regards,

louis van Paassen

4 REPLIES 4
toresenneseth
Frequent Visitor

Hi,

 

You can try the Financial Reporting Matrix custom visual by Profitbase. It has more flexibility regarding formatting and subtotals than the built-in matrix.

https://appsource.microsoft.com/nb-no/product/power-bi-visuals/WA200000642

 

Disclaimer! I work for Profitbase, so I'm not totally objective here 🙂

That's a nice looking visual, the basic version lets you change the total text!

louisvp
Helper II
Helper II

I did the following:

 

  • I switched the “Stepped layout off”
  • Put Wrap text on for the Row headers
  • Show +/- icons

Capture2.PNG

 

But now I need more space on the canvas, because now I have 3 columns instead of 1 column.

Does anyone have a suggestion to shrink my sollution from 3 to 1 column?

How did you get those SubTotal Names to happen? Like 'Own Expenses'?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors