Conditional format a bar chart over 75th Quartile

Hi SteveIOW ,

According to your description, I create a sample.

And create a measure as you mentioned.

Now for example in the bar chart RwCnt by p_spell_id, if we want to color the bar based on whether the RwCnt greater than the Quartile 7.25. Here's my solution.

1. Create a measure.

 

Color =
IF (
    MAX ( 'MainFacts'[RwCnt] ) >= CALCULATE ( [Quartile], ALL ( 'MainFacts' ) ),
    "Red",
    "Green"
)

 

Then in the visual format setting pane, select Bars>Colors>fx.

Select the measure in the field dialoge.

Get the correct result.

I attach my sample below for your reference.

 

Best Regards,
Community Support Team _ kalyj

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