cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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

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.

 

powerbi.PNG

3 REPLIES 3
Highlighted
Super User IX
Super User IX

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

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
New Member

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

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

Highlighted
Community Support
Community Support

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

Hi @abhinavit9 

 

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

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors