Forum Discussion
Anonymous
8 years agoNot applicable
Color one specific column
Hello, i have a matrix and i'll like to color this one column, because, left of this column are current values, right of this column are planed values. the column itself contains the forecast für...
Anonymous
4 years agoNot applicable
You're able to color whole columns with Measures.
You have to set a measure as the background for the values in your matrix. Then you have to create the code in the measure, for example:
ColorColumns =
var _val = SELECTEDVALUE(nameoftable[nameofcolumn])
return SWITCH(_val, "forecast1", "#ff9933", "#ffffff")
In this example every value forecast1 in the column would be colored orange, and everything else white
guh950
4 years agoMicrosoft Employee
This looks good, but how would I set a measure to color code for another measure column in a matrix?