Hello,
I have created a KPI visual in Power BI desktop. I would like the Trend Axis to be certain colors based on a table measure. I can't get the Neutral Color to work as expected. Below is the table of data. The Calc KPI column should drive the color of the KPI visual: 1=green, 2=yellow, 3=red. I would prefer to use the built in KPI visual (top right of table), but as you can see it is showing red, when it should show yellow (2022-Q1 KPI Calc = 2). I was able to create a similar visual (with a lot of extra steps) that displays the correct color, but I'd prefer not to create all those steps for multiple metrics. Any help would be greatly appreciated!
Thank you,
Andrea
Helpful resources
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
