cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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

Conditional formating.JPGresult.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Sage
Solution Sage

Re: Stacked Column chart conditional formatting not working correctly

Hi @RowanVU ,

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:

11.PNG

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.

 

View solution in original post

3 REPLIES 3
Highlighted
Super User II
Super User II

Re: Stacked Column chart conditional formatting not working correctly

Can you post a sample Power BI file ?





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Highlighted
Solution Sage
Solution Sage

Re: Stacked Column chart conditional formatting not working correctly

Hi @RowanVU ,

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:

11.PNG

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.

 

View solution in original post

Highlighted
Regular Visitor

Re: Stacked Column chart conditional formatting not working correctly

Thank you for your help. It works perfect now.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors