Bar Chart Conditional Formatting

[PPars2025]

I'm using the Stacked Bar Chart to display the grading of my field audits and want to apply color conditional formating but I am needing a measure.  I've tried the below DAX but it won't reference the correct data of "Score" within the 2026 New Detail Table.  I've changed the [Avg Score] to just [Score] but that is not working and the error I receive is, "The value for 'Score' cannot be determined. Either the column doesn't exist, or there is no current row for this column."  I added screenshots below if someone can help me with this measure and visual.

Bar Color =
SWITCH(
TRUE(),
[Avg Score] <= 2, "#D32F2F", -- Red (Needs Improvement)
[Avg Score] = 3, "#FBC02D", -- Yellow (Meets Expectations)
"#388E3C" -- Green (Exceeds Expectations)
)

[v-sshirivolu]

Hi @PPars2025 ,
I would also take a moment to thank @cengizhanarslan , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

[cengizhanarslan · Accepted solution]

1) Create (or reuse) a measure for the value you’re grading

For a bar chart that’s using “Average of Score”, define it explicitly:

Avg Score =
AVERAGE ( '2026 New Detail Table'[Score] )

 2) Use that measure in your color measure

Bar Color =
VAR s = [Avg Score]
RETURN
SWITCH (
    TRUE(),
    s <= 2,      "#D32F2F",          -- red
    s = 3,       "#FBC02D",          -- yellow
                 "#388E3C"             -- green
)

3) Apply it to the visual correctly

In the stacked bar chart:

• Format → Data colors

• Click fx

• Format by: Field value

• Based on field: Bar Color

[PPars2025]

Thank you!  Can you explain where to findthe following? I am not seeing data colors within the forman pane options:

• Format → Data colors

[Rufyda]

Hi @PPars2025 ,
Try to create (or use) a measure that aggregates Score, then use it for conditional formatting.
Avg Score =
AVERAGE ( '2026 New Detail Table'[Score] )

Use this measure for bar color

Bar Color =
SWITCH (
TRUE(),
[Avg Score] <= 2, "#D32F2F", -- Red (Needs Improvement)
[Avg Score] = 3, "#FBC02D", -- Yellow (Meets Expectations)
"#388E3C" -- Green (Exceeds Expectations)
)

If this response was helpful, please accept it as a solution and give kudos to support other community members
Regards,
Rufyda Rahma | MIE 

[PPars2025]

I am not sure I am following.  Are you saying to use two measures?