Stacked Column chart conditional formatting not working correctly

[Anonymous]

Hello Community

I currently have a stacked column chart in which I have WEEK numbers on the axis and FTR roadtankers as value.

FTR stands for "first time right" and it represents the percentage of all roadtankers that had no troubles. 

I would like to conditional format this stacked column chart so that when the percentage is higher than 80% the bar is colored blue and when it is lower than 80% the bar is red.

I applied the conditional formatting rules you can see in the first print screen to a table and to the stacked column chart. In the second print screen you can see it works correctly for the table but not for the stacked column chart. What am I doing wrong here?

Kind regards, 

Rowan

[boyerusmc]

Unfortunately, this isn't a solution for a STACKED COLUMN chart, only for column / clustered column charts. I'm still looking for a solution to this as well. I have a budget burn down chart - stacked column - where the full bar represents the entire budget with the "stack" being the remaining budget (balance) based on what's been billed. each column / bar is a different client. I would like to have any negative balances (more billed than total budget / below ZERO line) to be red.

Thanks!

[v-joesh-msft · Accepted solution]

Hi @Anonymous ,

The conditional formatting takes the difference between the minimum and maximum values as the cardinality of Percent, not the total. You need to adjust it to something like rules below:

Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you for your help. It works perfect now.

[kentyler]

Can you post a sample Power BI file ?