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...
please try below measure:
Planned_ConditionalFormat =
VAR CurrentLevel = SELECTEDVALUE('Date'[Hierarchy Level])
VAR PlannedHours = SELECTEDVALUE('MatrixTable'[Planned_Hours])
VAR PlannedPercent = SELECTEDVALUE('MatrixTable'[Planned_Percent])
-- Define thresholds
VAR ThresholdHours =
SWITCH(
CurrentLevel,
"Day", 8,
"Week", 40,
"Month", 160
)
VAR IsRed_Hours = IF(PlannedHours > ThresholdHours, 1, 0)
VAR IsRed_Percent = IF(PlannedPercent > 100, 1, 0)
RETURN
IF(IsRed_Hours || IsRed_Percent, 1, 0)