cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Is it possible to match color of legend column across all visualizations?

I have a Gantt chart and a donut chart.

I have dynamically populated column values for the legends on both of these charts. As the data is getting populated I noticed that the colors used for the Gannt chart are NOT matching those used in the donut chart.

I think this makes it difficult for new users of Power Bi to adopt this technology. I can't set the colors manually because it's alot of values and i want it to be dynamic.

Any guidance?

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Is it possible to match color of legend column across all visualizations?

hi, @Anonymous

 the color of legend column is filled dynamically by sort order of visual.

for example:

If I set "sort by" for Gantt chart to soft by Task Name desc

3.JPG

set "sort by" for donut chart to soft by Duration desc

4.JPG

Now colors of legend column of them are not matched

5.JPG

But when I set "sort by" for donut chart to soft by Task Name desc

6.JPG

Now colors of legend column of them are matched

7.JPG

So you could keep all the visualizations have the same "sort by", the color of legend column will be matched.

 

here is a demo pbix, please try it.

 

Best Regards,

Lin

 

 

 

 

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

Re: Is it possible to match color of legend column across all visualizations?

hi, @Anonymous

 the color of legend column is filled dynamically by sort order of visual.

for example:

If I set "sort by" for Gantt chart to soft by Task Name desc

3.JPG

set "sort by" for donut chart to soft by Duration desc

4.JPG

Now colors of legend column of them are not matched

5.JPG

But when I set "sort by" for donut chart to soft by Task Name desc

6.JPG

Now colors of legend column of them are matched

7.JPG

So you could keep all the visualizations have the same "sort by", the color of legend column will be matched.

 

here is a demo pbix, please try it.

 

Best Regards,

Lin

 

 

 

 

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

Re: Is it possible to match color of legend column across all visualizations?

hi, @Anonymous


Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

 

Best Regards,

Lin

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

Re: Is it possible to match color of legend column across all visualizations?

Thank you! I had written this off as not possible, amazing!

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 40 members 918 guests
Please welcome our newest community members: