How to set color to dynamic legend values in clustered column chart?

[abhinavit9]

Hello Everyone,

I am trying to create a report that has trailing 5 weeks of data. Every week when the data is refreshed the week numbers change and the color of the newest week in the chart sets automatically to light blue. I want to set these colors one time so that they don't change automatically. I want to design it in the way that the minimum week is the lightest blue and the maximum week is the darkest blue.

I tried conditional formatting but it's not working for me. Any insights will be really helpful. Thanks in advance.

[amitchandak]

@abhinavit9 , You may have to check custom visual. As of now, conditional formatting is not supported by the legend.

Check and vote for an existing Idea or create new https://ideas.powerbi.com/forums/265200-power-bi-ideas

[abhinavit9]

@amitchandak  Does that mean I have to create custom visuals using charts.powerbi.tips ? 

[v-diye-msft]

Hi @abhinavit9 

Yes, there's no direct way to achieve this currently.