Skip to main content

Power BI

Needs Votes

legend color in conditional formatting

Vote (281) Share
Jesús's profile image

Jesús on 09 Aug 2019 01:19:48

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

Comments (43)
Jesús's profile image Profile Picture

Harriet Stewart on 21 May 2022 18:07:33

RE: legend color in conditional formatting

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.

Jesús's profile image Profile Picture

John Nickell on 04 May 2022 15:29:44

RE: legend color in conditional formatting

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-8bc54f097385I 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.

Jesús's profile image Profile Picture

on 18 Apr 2022 21:03:18

RE: legend color in conditional formatting

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.

Jesús's profile image Profile Picture

on 18 Apr 2022 21:03:18

RE: legend color in conditional formatting

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.

Jesús's profile image Profile Picture

Cindy Botchis on 09 Mar 2022 14:36:49

RE: legend color in conditional formatting

Please! I have columns in my table that assign a consistent color to each of our business units. Works great with changing background colors in a matrix, but I would like to apply that column to legend members. Right now, I need to go into a line or bubble chart and manually assign the appropriate colors to each business unit.

Jesús's profile image Profile Picture

Cindy Botchis on 09 Mar 2022 14:36:17

RE: legend color in conditional formatting

Please! I have columns in my table that assign a consistent color to each of our business units. Works great with changing background colors in a matrix, but I would like to apply that column to legend members. Right now, I need to go into a line or bubble chart and manually assign the appropriate colors to each business unit.

Jesús's profile image Profile Picture

Cindy Botchis on 09 Mar 2022 14:35:50

RE: legend color in conditional formatting

Please! I have columns in my table that assign a consistent color to each of our business units. Works great with changing background colors in a matrix, but I would like to apply that column to legend members. Right now, I need to go into a line or bubble chart and manually assign the appropriate colors to each business unit.

Jesús's profile image Profile Picture

David Van Winkle on 02 Mar 2021 16:06:47

RE: legend color in conditional formatting

Unfortunately, I (and others) are unable to upvote even when signed in. The upvotes shown are likely a drastic under-representation of user feedback, so this upvote system needs to be fixed and basic functionality like this should be added regardless of upvotes.

Jesús's profile image Profile Picture

on 10 Nov 2020 00:28:10

RE: legend color in conditional formatting

I would like to add a conditional formatting for each column in a matrix, instead of using the conditional formatting in the whole matrix.

Jesús's profile image Profile Picture

Tara on 06 Jul 2020 00:17:02

RE: legend color in conditional formatting

Yes this is really needed! Now the legend and the colors in the visual just don't match.

Merged Idea (3)