Matrix-Colour formatting

[sshiny]

Is it possible to give different colours to "Total" and "Average"? I have given colours to the three months based on a measure-

Color =

var Month_Name = SELECTEDVALUE('Tag Usage Fact'[Month Name])

return

SWITCH(true(), Month_Name = "April", "Green",

Month_Name = "May", "Red",

Month_Name = "January", "Red",

Month_Name = "February", "Red",

Month_Name = "March", "Red",

Month_Name = "April", "Red",

Month_Name = "May", "Red",

Month_Name = "July", "Red",

Month_Name = "August", "Red",

Month_Name = "September", "Red",

Month_Name = "October", "Red",

Month_Name = "November", "Red",

Month_Name = "December", "Red",

Month_Name = "June", "Purple").

Now, I need to give colours to "Total" and "Average"

[memepu · Accepted solution]

Hi @sshiny ,

I have created a simple sample, please refer to it to see if it helps you.

Matrix-Colour formatting.pbix

Create a measure.

Measure = IF(ISINSCOPE('Tag Usage Fact'[[Month Name]),'Tag Usage Fact'[Color],"Orange")

If I have misunderstood your meaning, pelase provide more details with your desired output and pbix file without privacy information.

Best regards.