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

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

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
cef16166
New Member

No comment from Power Bi Team about this idea ?

Jenni_Raappana1
New Member

Please make this happen. Setting up colours manully in a dashboad where other colours are set condionally makes stacked bar chart a bad design choice.

thavener
New Member

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.

nishalit
New Member
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
Leydi_Ramos
New Member

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.


Jan_Wandsoe
New Member

Need this feature

othmane_chentou
New Member

I can't believe we still don't have this feature in 2023.. this is quite important

jeremy_brock
New Member

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

Liam_Wright
New Member

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.

timur_avci
New Member

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.