How to apply the same format for the whole total row

[hideakisuzuki01]

Hi,

I have a trivial question but I have been asked to make the format exactly the same as other system so here goes.

I have the below matrix but as you can see, the background color is only applied to the total values, but not to the "Total" nor the row total value("5,350").

Is there any way to apply the same background color all the way to "Total" and "5,350" in the below screenshot ?

Please note that I dont want to apply the blue background to the whole row headers, only the "Total".  

And likewise I only want the blue background for "5,350" , but not the whole row totals.

Is this possible ?

[hideakisuzuki01]

Worked great, thanks Farhan!

[FarhanAhmed · Accepted solution]

Create a DAX Expression for colors

Color = IF(HASONEVALUE(Table[year]),"White","Sky Blue")

Set the background of the value as and apply to totals only

you will get below results

[FarhanAhmed]

like wise if you want only totals to be colored change the color expression

Color = IF(HASONEVALUE(Table[Year]) || HASONEVALUE(Table[Month]),"White","Sky Blue")