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 (42)
- Merged Idea (3)
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.
RE: legend color in conditional formatting
This feature is very important for quickly highlighting important stats in a chart. Without it we are limiting the ability to present data that audiences can interpret at-a-glance. Please add this feature ASAP, Microsoft.
RE: legend color in conditional formatting
I need to create a stacked column chart where I can use conditional formatting based on another column in the data table. I can do this for scatter plots so hopefully the exact feature can be added to stacked column charts
RE: legend color in conditional formatting
I can't believe we still don't have this feature in 2023.. this is quite important
RE: legend color in conditional formatting
Need this feature
RE: legend color in conditional formatting
I need to be able to set the color of the series of a line chart based on the value of another column (conditional formatting) and I was surprised that it cannot be done in a line chart but it can be done in other types of charts. It doesn't make any sense that the functionality is for some things and not for others that are similar. It would help users a lot if they unify the conditional formatting of data colors for all charts.
RE: legend color in conditional formatting
Currently, when you add a field for legend in stacked/clustered column or bar chart, you can't use conditional formatting for data colors. you can set them manually but it would be great to be able to use conditional formatting here, like that you can have predefine colors for stacks that you can map dynamically.
There may be a limitation when the conditional formatting will not return a color for a stack, in this case I suggest either having a default color or an error message indicating an invalid color value.
Compared to other dataviz tools, this point appears to be a limitation of Power BI and may be a barrier to adoption.
Regards
RE: legend color in conditional formatting
I feel like this is highly overlooked, I have had many examples of when my reports look beautiful and ready to go and then the slices of my pie chart or column chart that have pieces split up by project, manager, or any other categorical just change color to seemingly whatever Power BI wants it to and many times it has been colors that are starchily different from the report theme. Please at least have the theme colors play a role in predicting what the user wants.