Clustered Column Chart Data Colors Change Dynamically

[Anonymous]

Could you Please help me or suggest someone Regarding Power bi Requirement.

Visuval 1 : I’ve  Slicer Contains Job Name If end User Select Job Name filter the Job Name.
Visuval 2 : Clustered Column Chart this Visuval contains

                    X-axis Job Name and  EX : Profit Job

                    Y-axis Duration Job Run time  

                   Legend Pipe Line End Time  EX : 2021-07-13 12:11:35, 2021-07-14 12:48:49,  2021-07-13 10:33:30 etc…
                   Values : Duration  EX : 30,10,15,20,12,15

scenario : Below Chat Avg Duration Blue Dashed Line, above Avg. we have values 30 and 20 two bars and below avg. line 10,15,12,15 bars
                   we need a above avg. Line bar colur Should be Red and Below Avg. Bars Green.

[V-lianl-msft]

Hi @Anonymous ,

If you have a legend field in the Clustered Column Chart, you cannot dynamically change the color of the bar.

Try removing the legend field and settinga measure to conditional formatting.

Please refer to the same thread:

https://community.powerbi.com/t5/Desktop/Conditional-Formatting-based-on-Average-Value-of-Measure/m-p/588642 

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