Forum Discussion
Conditional Formatting within Maxtrix visual
Hi RVIG -First, you need to create a measure that will evaluate whether the average speed falls within the specified ranges for each phase.
Speed Formatting =
VAR AvgSpeed = AVERAGE('YourTable'[Speed])
VAR Phase = SELECTEDVALUE('YourTable'[Phase])
RETURN
IF(
(Phase = "Phase 1" && (AvgSpeed >= 11950 && AvgSpeed <= 12050)) ||
(Phase = "Phase 2" && (AvgSpeed >= 9150 && AvgSpeed <= 9250)),
1, // This value will be used to apply the formatting
0 // This value will not apply formatting
)above measure helps in creating the conditional formatting
go to format pane, cellelement
Set up a rule to apply formatting based on the value of the Speed Formatting measure.
If value: is
Value: 1
Color: Choose green or the color you want to use for highlighting.Hope this works to highlight the background of speed.
Hi RVIG -First, you need to create a measure that will evaluate whether the average speed falls within the specified ranges for each phase.
Speed Formatting =
VAR AvgSpeed = AVERAGE('YourTable'[Speed])
VAR Phase = SELECTEDVALUE('YourTable'[Phase])
RETURN
IF(
(Phase = "Phase 1" && (AvgSpeed >= 11950 && AvgSpeed <= 12050)) ||
(Phase = "Phase 2" && (AvgSpeed >= 9150 && AvgSpeed <= 9250)),
1, // This value will be used to apply the formatting
0 // This value will not apply formatting
)
above measure helps in creating the conditional formatting
go to format pane, cellelement
Set up a rule to apply formatting based on the value of the Speed Formatting measure.
If value: is
Value: 1
Color: Choose green or the color you want to use for highlighting.
Hope this works to highlight the background of speed.
Hi rajendraongole1,
This works perfectly. I managed to apply it to my case.
Thanks a lot for your quick answer and support
RVIG