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...
Measure:
Drill Level =
SWITCH(
TRUE(),
ISINSCOPE('Date'[Date]), "Daily",
ISINSCOPE('Date'[Week]), "Weekly",
ISINSCOPE('Date'[Month]), "Monthly",
BLANK()
)
Format Planned =
VAR CurrentLevel = [Drill Level]
VAR Hours = SUM('Table'[Planned Hours])
VAR Percent = SUM('Table'[Planned %])
RETURN
SWITCH(
TRUE(),
CurrentLevel = "Daily" && Hours > 8, 1,
CurrentLevel = "Daily" && Percent > 100, 1,
CurrentLevel = "Weekly" && Hours > 40, 1,
CurrentLevel = "Weekly" && Percent > 100, 1,
CurrentLevel = "Monthly" && Hours > 160, 1,
CurrentLevel = "Monthly" && Percent > 100, 1,
0
)
Use the Format Planned measure in Conditional Formatting for the Planned column in the matrix visual. Set formatting rules where 1 applies red color and 0 applies no color.
💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn