Conditional Formatting within Maxtrix visual

[RVIG]

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

[rajendraongole1 · Accepted solution]

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.

[RVIG]

Hi @rajendraongole1,

This works perfectly. I managed to apply it to my case.

Thanks a lot for your quick answer and support

RVIG