cancel
Showing results for 
Search instead for 
Did you mean: 
0

Conditional Formatting Data Label - Bar Chart

When using data labels on a bar chat, I am able to apply conditional formatting to the bar colour. For some reason, when I apply the exact same rules to conditional formatting on a data label, it does not seem to be working.

SamMitchellTVG_0-1653644072127.png

 

My colleague has tried the same as is experiencing the same problem.

Status: Delivered

Hi @SamMitchellTVG,

 

It is caused by design(ICM 304359329). Power BI will format colors of data labels according to an aggregated value, such as the sum of all the values. So in this case, all the data labels will be red for the total of all values is positive.

 

Here is an idea in Power BI Ideas that gives suggestions to this issue and you could vote for it as well. Thanks in advance!

https://ideas.powerbi.com/ideas/idea/?ideaid=8bd55e80-3ddd-4547-9f30-61540252dba9

 

Best Regards,

Community Support Team _ Caiyun

Comments
v-cazheng-msft
Community Support
Status changed to: Delivered

Hi @SamMitchellTVG,

 

It is caused by design(ICM 304359329). Power BI will format colors of data labels according to an aggregated value, such as the sum of all the values. So in this case, all the data labels will be red for the total of all values is positive.

 

Here is an idea in Power BI Ideas that gives suggestions to this issue and you could vote for it as well. Thanks in advance!

https://ideas.powerbi.com/ideas/idea/?ideaid=8bd55e80-3ddd-4547-9f30-61540252dba9

 

Best Regards,

Community Support Team _ Caiyun