PBI Matrix Help

[dbldee5]

Can anyone help, I am trying to get my matrix from showing two total lines. I need all the subtotals, then just one Course total at the end.. Also, instead of making it say Course Total, can I make it more dynamic and say the total of the Course Value? For this example, I would like for it to say ACG2071C Total

[dbldee5]

How do I make it stop showing two total lines?

[Anonymous · Accepted solution]

Hi @dbldee5 ,

As far as I know, currently Power BI doesn't support us to show dynamic subtotal name by measure.

However, we can DIY the subtotal for each level.

Row subtotals > Turn on "Per row level" > Select the level you want to change in "Row level"

Result is as below.

If you want to turn off the subtotal of which level, you can select the level and turn off the subtotal.

Best Regards,
Rico Zhou

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

[danextian]

I really wish there was a way to conditionally show a different total text but it is either Total or a custom text for all total rows. There are similar ideas that have been raised which need votes.
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=13861204-de19-4bc2-be6c-e63c7bac81c6 

[anmolmalviya05]

Hi @dbldee5, Currently this feature is not available in Power BI to make the total name dynamic.

[amitchandak]

@dbldee5 , As of now you can do static rename of the total