Forum Discussion
jalaomar
Helper IV
Helper IVAdd conditional formatting to a measure
Dear Experts,
I have a matrix table showing different values at row level and was wondering if someone can support adding conditional formatting in the Value2 measure?
In the source table there are the follwing columns
for the ActualSchedule Date I would like to add conditional formatting in the Value2 measure: If Color 5 = Green, Color 3 = Yellow, Color 1 = Red & Color 0 = light Blue. Want to also add conditional formatting to the font as well, if Color Green = white font color, Yellow = Black font color, red = white font color
This is the Matrix tables with all the values, Tollgates in column section and Values in row section.
This is the measures used to add to the value section
Value2 = SWITCH(
MAX('Row'[Row]😞
"ActualSchedule"; CONVERT(MAXX(FILTER(Tollgates;Tollgates[BaselinePurpose]="ActualSchedule");Tollgates[ActualSchedule Date]);STRING);
"Contract";CONVERT(MAXX(FILTER('Tollgates';Tollgates[BaselinePurpose]="Contract");Tollgates[ActualSchedule Date]);STRING);
"Days Variance";FORMAT([1Days Var.]; "##0");
"%Performance";FORMAT([%Performance]; "#%"))
anyone that can support?
BR
J
No RepliesBe the first to reply