Forum Discussion
Solved
Matrix-Column colour
Is it possible to give, all the sub-columns under April in a particular colour, May in a particular colour and June in a particular colour?
Dinesh The above measure dint work, however the below measure worked for me-
Color =var Month_Name = SELECTEDVALUE('Tag Usage Fact'[Month Name])returnSWITCH(true(), Month_Name = "April", "Green",Month_Name = "May", "Red",Month_Name = "Proc Total", "Red",Month_Name = "Average", "Red",Month_Name = "June", "Purple")
Dinesh The above measure dint work, however the below measure worked for me-
Color =
var Month_Name = SELECTEDVALUE('Tag Usage Fact'[Month Name])
return
SWITCH(true(), Month_Name = "April", "Green",
Month_Name = "May", "Red",
Month_Name = "Proc Total", "Red",
Month_Name = "Average", "Red",
Month_Name = "June", "Purple")