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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
dramnath_1981
Frequent Visitor

How to change Label in Matrix visualization

Hi,

 

I have a matrix visual and with the help of a DAX formula, I arrived at the Variance as a part of the Matrix itself. But unfortunately, I am not sure how to change the Label which says "Total" to "Variance".

 

Kindly help with this as otherwise, Total label is completely looking irrelevant.

 

Capture.PNG

Regards, Ramnath

1 ACCEPTED SOLUTION
Pragati11
Super User
Super User

Hi @dramnath_1981 ,

 

You can do something as shown below:

Pragati11_0-1603815573315.png

 

Thanks,

Pragati

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

2 REPLIES 2
Pragati11
Super User
Super User

Hi @dramnath_1981 ,

 

You can do something as shown below:

Pragati11_0-1603815573315.png

 

Thanks,

Pragati

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Hi,

 

Currently, I use the below formula to arrive at Variance in the above table which I have posted originally. But one more challenge is, I don't know how do I add Variance % in the last row below variance row.

 

Any help is much appreciated.

 
Variance =
IF (
ISFILTERED ( Query4[YM] ),
SUM ( Query4[spends] ),
CALCULATE (
SUM ( Query4[spends] ),
VALUES ( Query4[WK_D] ),
Query4[YM] = 2020010
)
- CALCULATE (
SUM ( Query4[spends] ),
VALUES ( Query4[WK_D] ),
Query4[YM] = 202009
)
)

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.