Forum Discussion

sshiny's avatar
sshiny
Helper II
4 years ago
Solved

Matrix-Colour formatting

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"

 

Need Help
Show and Tell
  • memepu's avatar
    memepu
    4 years ago

    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.

1 Reply

  • memepu's avatar
    memepu
    Resolver II
    4 years ago

    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.