how to Create a row from the total values of the columns?

[Anonymous]

Hello All,

I am a newbie at Power BI and facing lots of problems. I have to create a matrix and show the sum of all columns as a new category.. let us say PLANT. as in the picture you see the total row, I want to replace that row with a new row, which does exactly the same sum of the columns but I want to name it as plant.

any idea how it can be achieved? 

Thanks..

Picture for reference. 

@MFelix @amitchandak @Jihwan_Kim @selimovd 

[MFelix · Accepted solution]

Hi @Anonymous ,

If the values on that new row is fixed in this case plant you can change the option on the matrix options on the Subtotals you have the option to change that label.

[Anonymous]

HI.. @MFelix

Thankyou so much for the answer it worked.