Conditional Formatting by Quarter

Anonymous ,

So the percentage value in your matrix is a measure you have created and you need to color the highest and lowest measure value per quarter, right?

If so, you need to convert the measure to calculate column and then create a measure to set the color rule:

Color =
VAR Max_Percentage =
    CALCULATE ( MAX ( Table[Percentage] ), ALLEXCEPT ( Table, Table[quarter] ) )
VAR Min_Percentage =
    CALCULATE ( MIN ( Table[Percentage] ), ALLEXCEPT ( Table, Table[quarter] ) )
RETURN
    SWITCH ( Table[Percentage], Max_Percentage, "Red", Min_Percentage, "Blue" )

Then click condition formatting pane of the matrix visual and select Field Value based the Color measure:

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.