cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ScottAnderson
Frequent Visitor

Change the Color of First Bar That Meets Certain Criteria

Below is a graph of what I'm trying to accomplish. The bars are sequenced from Step 1 to Step 2 to Step 3, etc. What I'm trying to do is have the first bar that scores a 3 or below change color. Any bars after that color-changed bar could be the same color as the previous bar(s), or a different color. I've tried multiple iterations with conditional formating, but can't seem to find anything that works. Any thoughts on how to accomplish this?

BarChart Color at Step.jpg

 

2 REPLIES 2
V-lianl-msft
Microsoft
Microsoft

Hi @ScottAnderson ,

 

Please refer to these:

https://docs.microsoft.com/en-us/power-bi/visuals/service-tips-and-tricks-for-color-formatting 

https://docs.microsoft.com/en-us/power-bi/visuals/service-getting-started-with-color-formatting-and-... 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for the response. I looked at the resources and feel like I have a good sense of conditional formatting. However, I think I'm asking for something a little more complex than a simple conditional format.

 

In the example above, Step 3 and Step 4 are the same value, but only the first one is red. I could set a conditional format to turn any bar that is 3 or below to Red, in which case Step 3 and Step 4 would both be red. But, I only want the first bar that is 3 or below to be red, with the subsequent bars (even if the same value) being a different color. It's conditional color formating based on conditions of previous responses; if Step 1 is 3 or below, change the bar color for Step 1, but don't make the bar color for Step 2 the same even if Step 2 is 3 or below. I have set up a conditional column (IF/Then) that will tell me which step is the first to be scored at a 3 or below, but then I don't know how to translate that into a colored bar.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors