Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

legend color in conditional formatting

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
Status: Needs Votes
Comments
fbcideas_migusr
New Member

Please, how difficult can it be. We can already sort by column, why not color by column. Doesn't have to be advanced, it could just refer to another column, then we can either manually add a lookup function or a custom function to give rgba values, hex values or similar. Absolutely critical to make visualizations coherent and understandable.

Sarah_Powell
New Member

Agreed with the other commenters that this is essential for making stacked and clustered column charts useful and legible at a glance. Hand-picking colors for legend entries that might change in a future data refresh is no solution. Even worse, because Power BI doesn't respect the JSON color scheme and picks any random color, new legend entries could be hot pink or mud brown, and on branded reports presented to business users that is not acceptable.

sean_hofland
New Member

I am, at the moment, mainly interested in setting the transparency of the bar chart colors and changing the solid color into a (diagonal lines for example)

fbcideas_migusr
New Member

This is a problem for report consistency. It's not possible to reuse defined category colours in stacked bar charts as they're used in regular bar charts.

fbcideas_migusr
New Member

The legends could also do to reflect the transparency of a colour that a user sets. Currently, it just shows the selected colour at its default 0% transparency, even if this has been amended in the side panel.

fbcideas_migusr
New Member

It's 2024 and it's phenomenal that we can't even dynamically color our legends (e.g. in a stacked column bar) by having a conditional formatting option by e.g. a rule or a field.


Should be quite simple to implement; hoping this would come soon 🤞🏻

Minh_Do
New Member

It's Mar 2024 and now I'm voting for a 2019 idea. It sounds like a vote for fun...

For my case, I need to color the bar chart based on another column, not the legend column.


pbastian
New Member

Another feature that I can easily code in VBA for making an Excel chart, but cannot be done in Power BI. Easy to code in DAX, but not available to programmatically assign to the legend.


As others have said here, this is now a 5-year old request for something basic. Sad to say, but a lot of people believe that because its called "POWER" BI, it is more POWERful than MS Excel across the board. But alas, I must tell my clients, this is simply a myth. There are things you can do in Excel that PBI cannot do, and vice versa. But for them to not offer this kind of basic customization in PBI seems odd to me.

ristoguijken
New Member

Expressing my need for this functionality here. This is really important to maintain consistent colors between visuals. Story telling is very hard without this.

wdehaas2
New Member

It would be very nice to see that FX button for conditional formatting on the legend as well. A client requested this and I couldn't believe this option was not available in Power BI Desktop. I couldn't find any workaround excepct using a custom visuals (search for Likert Scale in the Custom Visual App Store).