Most Valuable ProfessionalRaise the Bar | Dynamic Target and Bar Color
For the Raise The Bar Quickviz challenge, I created a bar chart in Power BI that uses field-value conditional formatting and error bars to show the target.
This is one of my favorite visuals for showing performance against a target. Each entire bar changes color based on the result: green when the category meets or exceeds the target, gray when it doesn’t. The target itself is shown with error bars (with a label), so it’s easy to see who reached last year’s level and who didn’t.
The subtitle is fully dynamic and lists the categories that reached the yearly target. It respects slicers and improves accessibility for users who rely on screen readers.
The DAX I used for the color change (use it as field value when using conditional formatting):
Bar Color Conditional Formatting =
IF([Sales YoY]> 0 ,
"#25C3BE",
"#D2D6D1")
I wrote an article and created a video that explains how to use error bars for target visualization. You can find them here: Article & Video