Forum Discussion
conditional formatting
I have created a matrix table with planned and available columns. With the selection of slicer, matrix table shows the data in hours and %. I need to put the conditional formatting for planned colum...
Create this measure
Condition_Daily_Data =
SWITCH(TRUE(),
SUM(ConditionalFormatting[Hours])>8,1,
SUM(ConditionalFormatting[%])>100,1,0)
Then apply conditional formatting using the rules in format style.
Create a flag using your condition and apply a color.