legend color in conditional formatting

[jesus_h_aguirre]

when you have a graph to which you can apply a conditional format the legend stays with the default color, the legend should be put with the colors of the mixed conditional format

[nishalit]

Conditional formatting is only possible in the charts where legends or Columns series is not enabled on a chart. Extending conditional formatting option for legends and column series in Stacked charts would be handy. There are uses cases for this.

[jnickell1]

I'm cross posting my comment from the idea that more directly linked to what I'd like to see.

The merged idea is: https://ideas.powerbi.com/ideas/idea/?ideaid=ce24e22b-e605-4c6c-9333-8bc54f097385

I think this idea was merged incorrectly. As I understand it and as it applies to me. What brought me here was an attempt to apply conditional formatting only within the context of a single column.

I'm unable to attach an image, so I will try to describe in words:

I have a matrix with Year/Month hierarchy for the columns.

I have a single measure for values

I would like to use conditional formatting to visualize the highest and lowest values within a given month.

Month 1 and Month 2's conditional formatting should be distinct.

I'm able to create a format key that correctly ranks the values within a month but the conditional formatting for month 1 is thrown off because there are more values in month 2 (5 vs 8 in my case). In month 1 the 5th ranked value is the lowest value but it is formatted as a middle rank value because there is an 8th value in month 2.

[harriet_stewart]

Yes, this is a real limitation for showing survey results where you want the colors from question to question to be one color for negative and another color for positive respones, even when the questions are different.

[thomo127]

Agreed.

It is frustrating that you can use conditional formatting to colour on simple bar charts but have to manually assign colour codes to a legend when a second dimension is added to the same chart.

It would be fantastic if Microsoft could find a solution to this issue.

[jthiart]

Agree,

I find it very distracting and poor style if the legend colours are not consistent in a report over all visuals.

[rcleveland]

My legend changes based on Slicer selections, and it's a massive limitation that I cannot control the colors in the visualization. With hundreds of selections, I cannot set the colors manually...

[zjd4]

The ability to specify bar colors in stacked bar charts (dynamically or manually) even when legend is used seems like a common enough requirement that you would allow this functionality...

[Jakub_Fuchs]

It is insane that this is not possible. I've watched so many videos, checked so many forum posts and even tried to map colors to particular data values (which I failed to accomplish) and yet to find out I still can't solve this.

[robert_hawke]

i spent 1 hour trying to figure out how to make this happen, just to realize it cannot be done. Come on Microsoft, why not enable conditional formatting for these charts?

[LEAVITW]

Power BI for some reason is randomly changing some of my stacked bar chart color schemes. I have two central metrics that I'm using in the Legends, but as Themes are applied to the whole document, the other one (which has a different color scheme e.g. respondent efficiency vs. reported burnout symptoms) is much more of a pain to get the color scheme correct. Would be nice to be able to adjust that across the entire document/report.