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 (39)
- Merged Idea (3)
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.
RE: legend color in conditional formatting
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)
RE: legend color in conditional formatting
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.
RE: legend color in conditional formatting
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.
RE: legend color in conditional formatting
It's 2023 and still no progress here. PowerBI has in some points like this no connection to intelligence and power. Same with limited mekko charts especially without conditional formating, or no synchronized drilldown for all charts with same hierarchy. Some basic stuffs are missing in PowerBI.