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)
- Merged Idea (3)
RE: legend color in conditional formatting
I found this wish because I tried to 'hardcode' colours for different categories in multiple stacked column charts. Preferably through measure or value in a table.Now I need to change the colours manually in each graph. And redo this in case of new categories. That's a lot of time spend on things that can be done 'automatically' with other (parts of) visuals.I think it's mostly the discrepancy between the options of customisation in visuals that makes it hard to understand why this isn't possible yet...
RE: legend color in conditional formatting
Would be a great quality of life change.Would facilitate pipeline visualizations using the 100% stacked bar / column visuals. >> |New | Under Review | In Progress | Under Review | In Progress | Finalized | Closed
RE: legend color in conditional formatting
This default color bug is driving me crazy and it has been 5 years now since the first request made.. please sort it out asap..
RE: legend color in conditional formatting
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).
RE: legend color in conditional formatting
Expressing my need for this functionality here. This is really important to maintain consistent colors between visuals. Story telling is very hard without this.
RE: legend color in conditional formatting
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.
RE: legend color in conditional formatting
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.
RE: legend color in conditional formatting
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 🤞🏻
RE: legend color in conditional formatting
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.
RE: legend color in conditional formatting
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.