Chart legend to match conditional formatted column

[Anonymous]

I have a chart that has conditional formatted columns based on a value (positive green, negative red). This causes the legend to show incorrectly. I guess because there is a posibility that a series could have more than 1 colour due to conditional formatting and from my understanding the legend can only show one colour per series. Is it either possible to remove just 1series from the legend or for the legend to show muliple colours?

[v-eachen-msft]

Hi @Anonymous ,

Here is my sample data.

If you want to show multiple colors, you can put the “Difference” field into column series.

When you used the "Conditional formatting", the label color of "Difference" has nothing to do with the displayed column color.

Best Regards,

Eads

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

[Anonymous]

Hi @v-eachen-msft,

Thanks for your reply. I agree when you say that  'the label color of "Difference" has nothing to do with the displayed column color'. But thats the problem, difference is shown as green but really doesn't relate to anything. The user will look at the chart and struggle to understand what the colour green and "Difference" relates to. Ideally "Difference" wouldn't show in the legend once conditional formatting has been put in place, is there a way of removing "Difference" from the legend?

[v-eachen-msft]

Hi @Anonymous ,

By my test, I'm afraid that we cannot achieve your requirement in Power BI currently.

You could submit your idea in Power BI ideas Forum and add your comments there to improve Power BI and make this feature coming sooner.

Best Regards,

Eads

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

[Anonymous]

Hi @v-eachen-msft,

thank you for the quick reply, seems strange that its not somthing that would of been developed alongside the conditional formatting of colours within visuals. 

I see somebody has already posted the idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/38335789-legend-color-in-conditio... - @jesús please vote.

[Anonymous · Accepted solution]

There is a visual that provides an answer to this that was realised in August 2019 called 'xviz multiple axis chart', see screen shot below: