Forum Discussion
Solved
Bar Chart Conditional Formatting
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 th...
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
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