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

[louisvp]

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

Kind regards,

louis van Paassen

[louisvp]

I did the following:

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

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?

[MikeAinOz]

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

[toresenneseth]

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 🙂

[MikeAinOz]

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