PowerBI Column Chart - Conditional Formatting Problem

[mstone3]

Hello, I have a simple PowerBI column chart with a few conditional formatting rules:

If value is greater than 0 and less than 6, format blue

If value is greater than or equal to 6 and less than 10, format orange

If value is 10 or greater, format pink.

The result is show below - as you can see I'm getting two different colors for the same exact whole number value.  Values of 1 are both blue and orange.  Values of 6 are both orange and pink.

Thanks very much for any assistance!

[Anonymous · Accepted solution]

Hi @mstone3 ,

First of all, many thanks to for very quick and effective replies, and I will give some additions below:

1.Create the simple table.

2.Create the new measure to filter conditional formatting.

conditional format = 
VAR sel = SELECTEDVALUE('Table'[Values])
RETURN
IF(sel > 0 && sel < 6, "blue",
    IF(sel >= 6 && sel < 10, "orange",
        IF(sel >= 10 && sel < 100, "pink")
    ) 
)

3.Select the color in the Bars pane.

4.Select the Field value and measure.

5.The result is shown below.

Best Regards,

Wisdom Wu

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

[Anonymous]

@mstone3  What's the complete rule for when the value is 10 or greater?

[mstone3]

Hello, the complete rule is greater than 10 or less than/equal to 100.  The are no values that would go beyond 100.  Thank you!

[Anonymous]

@mstone3  Can you share a snag of your conditional formatting pane the way I did above?

[Wilson_]

Hi mstone3,

Can you please share a sample pbix file? (If you don't know how, please check the pinned thread in the forum.) It would make debugging your issue easier. 🙂