Forum Discussion
Conditional Formatting within Maxtrix visual
Hello everyone,
I'm using BI to monitor data from a large amount of CSV files which contains data from an endurance test.
This endurance test repeat a cycle containing 2 phases where I'm monitoring the engine speed.
I have the following matrix visual where I plot the cycles name on the rows, the Phase on the columns and the average of the speed as Values.
To help analyse the data, I want to add a conditional formatting on the Average Speed. I mean, if the speed average is between 12000 +/- 50rpm on phase 1 and 9200 +/-50 rpm on phase 2, I want to highlight in green the values.
As Average of Speed is a unique column, I can only set one rule to format my data.
If anyone has an idea, it would be very helfull.
Thanks in advance for your time and support
RVIG
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.
2 Replies
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
