Clustered Column Chart Data Colors Change Dynamically

Question

Could you Please help me or suggest someone Regarding Power bi Requirement.Visuval 1 : I’ve &nbsp;Slicer Contains Job Name If end User Select Job Name filter the Job Name.Visuval 2 : Clustered Column Chart this Visuval contains&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;X-axis Job Name and &nbsp;EX : Profit Job&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y-axis Duration Job Run time &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Legend Pipe Line End Time &nbsp;EX : 2021-07-13 12:11:35, 2021-07-14 12:48:49, &nbsp;2021-07-13 10:33:30 etc…&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Values : Duration&nbsp; EX : 30,10,15,20,12,15scenario : 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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; we need a above avg. Line bar colur Should be Red and Below Avg. Bars Green.&nbsp;&nbsp;

v-lianl-msft · Answer

Hi Anonymous&nbsp;,
&nbsp;
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&nbsp;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&nbsp;
Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Clustered Column Chart Data Colors Change Dynamically

1 Reply

Related content

Clustered column chart incomplete legend

Need a stacked clustered column chart

Multiple line and clustered columns chart

Clustered Column Using Inscope

Dynamic Clustered Column Chart