How to reverse legend color order but keep the text order

[Anonymous]

Hi!

I'd like to reverse legend color order but keep the text order.

There are a few questions and solutions posted on this forum for sorting chart legends and creating custom sort order for them. However, I couldn't find one that solves the issue of reversing the legend color order.

Here's my table that contains the sales figure for each day.

I want to create a chart that shows the total sales for each month, using year as its legend. Here's the linechart:

QUESTION:

How can I reverese the legend colors so that the most recent year uses the color #1 and so on? That is,

2023 = light blue

2022 = dark blue

2021 = orange...

AND, keep the order of the legends (2019 left, 2023 right)?

Currently, I can achieve this by using my year_sort_order column. However, it will change the displayed legend order.

If I then sort the legends descending, the legends will revert back to their original colors.

[Anonymous]

Hi @Anonymous ,

I think you can custom your theme, you may refer to below offical blog to learn more details.

For reference: Use report themes in Power BI Desktop

Or you need to change the legend color in visual format as mlsx4 mentioned as above.

Best Regards,
Rico Zhou

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

[Anonymous]

Thanks for the suggestion, I ended up reversing the theme colors. 

It's a shame that there isn't an option to sort chart legend colors by the legend value, independent from the legend value order. 

[mlsx4]

Hi @Anonymous 

If you want to keep the colours in that way for all the report, then you should modify your main theme once and you'll have it for everything. If you only want it for the graph, I think you will have to do it manually