Solved: Re: How to control subtotal labels?

ImkeF · ‎04-29-2018

Is it possible to control the labels of the subtotals so that not just "Total" will be shown, but also the name of the category like so?:

Matrix chart with "Row Subtotal Position" = "Bottom"

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

MattAllington · ‎04-29-2018

I have looked many times and have never found a way. I assume it is not possible.

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

View solution in original post

v-jiascu-msft · ‎04-30-2018

Hi @ImkeF,

There are some ideas. But none of them have many votes.

power-bi-ideas/suggestions/19567204-subtotals-and-total-renames

power-bi-ideas/suggestions/33149917-totals

power-bi-ideas/suggestions/32794447-customizing-the-word-total

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Ahmedx · ‎01-20-2023

is this solution right for you?

https://dropmefiles.com/jXfSf

ksawyer · ‎07-31-2023

How did you do this? This looks like something I can use right now.

elainepowell · ‎03-21-2023

How did you change those subtotal labels? The file you linked is no longer available.

I've got a ridiculously complicated matrix and being able to dynamically name the subtitle labels would really help.

Insights · ‎01-20-2023

currently it allows you to edit the label generally for a category but would be helpful to have more...

MattAllington · ‎04-29-2018

I have looked many times and have never found a way. I assume it is not possible.

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

ImkeF · ‎04-29-2018

Thanks Matt!

What surprises me is that I cannot find an feature request / idea for it. But maybe I didn't use the right keyword.

So before closing this thread I'd like to ask folks to post the link to the idea here if they find it.

Thanks!!