topic Re: Conditional Formatting - Bar Chart from Field values in Desktop

Conditional Formatting - Bar Chart from Field values

3mmanuel_12 — Fri, 13 Mar 2026 06:54:35 GMT

Hello All,

Can anyone help me.

I have a bar chart to show SLA category.

I need to implement a conditional formatting based on the SLA Policies. My issue is all measures work fine but the bar does not match with the appropriate color.

Note that the average time is in Hours

See image below.

Thanks for your support.

Re: Conditional Formatting - Bar Chart from Field values

grazitti_sapna — Fri, 13 Mar 2026 07:14:41 GMT

Hi 3mmanuel_12 ,
Your measure should look like below(as you memtioned it's working fine)

SLA Color = 
VAR AvgHours = [Average Time Hours]

RETURN
SWITCH(
TRUE(),
AvgHours <= 24, "#28A745", -- Green
AvgHours <= 48, "#FFC107", -- Yellow
AvgHours > 48, "#DC3545", -- Red
"#808080" -- Default Grey
)

Now follow the below steps:

In your Bar Chart:

Select the visual
Go to Format Pane
Expand Data Colors
Click fx
Choose: Format by → Field value
Based on field → SLA Color

This should fulfill your requirement

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

🔗 Curious to explore more? [Discover here].

Let’s keep building smarter solutions together!

Re: Conditional Formatting - Bar Chart from Field values

3mmanuel_12 — Fri, 13 Mar 2026 07:27:57 GMT

Thanks for your answer.

My measure is something like that.

CF Resolution Target =

VAR _value=[Avg Resolution Time]- [Tickets Resolution Target]

RETURN

IF(

_value>0,"Red", "Green"

)

As you see in the image , in the table this measure returns the expected value Green or Red based on the condition.

But it does not works in the bar chart.

I used the same process as you mentioned above to apply color format

Re: Conditional Formatting - Bar Chart from Field values

AnalyticPulse — Fri, 13 Mar 2026 08:21:38 GMT

if you put hex code in measure it should work, select the colour from conditional format options visualization based on feild value

Re: Conditional Formatting - Bar Chart from Field values

3mmanuel_12 — Fri, 13 Mar 2026 08:23:14 GMT

I already use hex code for color but still the same issues.

Re: Conditional Formatting - Bar Chart from Field values

AnalyticPulse — Fri, 13 Mar 2026 08:28:24 GMT

can you please try the measure using switch function, as suggested by grazitti_sapna . it always works for me.

Re: Conditional Formatting - Bar Chart from Field values

3mmanuel_12 — Fri, 13 Mar 2026 08:48:06 GMT

If you look at my measure and the bar chart. I added the color value as data label.

As you can see the measure returns the exact value that i need. But the bar chart color does not reflect the same color.

Re: Conditional Formatting - Bar Chart from Field values

v-saisrao-msft — Mon, 16 Mar 2026 10:21:34 GMT

Hi 3mmanuel_12,

Thank you grazitti_sapna AnalyticPulse, for your insights,

I reproduced the scenario using sample data in Power BI Desktop and was able to observe the same behavior where the measure returns the correct Red/Green values, but the column chart color does not reflect the same result.

Thank you.

Re: Conditional Formatting - Bar Chart from Field values

v-saisrao-msft — Fri, 20 Mar 2026 04:35:17 GMT

HI 3mmanuel_12,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

Thank you.

Re: Conditional Formatting - Bar Chart from Field values

v-saisrao-msft — Mon, 23 Mar 2026 03:37:34 GMT

HI 3mmanuel_12,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.