Clustered Column Chart Data Colors Change Dynamically

Anonymous — Wed, 21 Jul 2021 10:16:44 GMT

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.

Re: Clustered Column Chart Data Colors Change Dynamically

V-lianl-msft — Fri, 23 Jul 2021 05:40:17 GMT

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.

topic Clustered Column Chart Data Colors Change Dynamically in Developer

Clustered Column Chart Data Colors Change Dynamically

Re: Clustered Column Chart Data Colors Change Dynamically