Forum Discussion
Stacked Column chart conditional formatting not working correctly
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
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.
4 Replies
Can you post a sample Power BI file ?
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.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!
