Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello,
Is it possible to set my guage color to green if > target value and red if <. I'm using measures to get my values, so no table data. How would I achieve this if possible?
Solved! Go to Solution.
Hello @Russo
You’ll need a DAX measure that returns a color name or hex code based on the comparison:
IF([ActualValue] <= [TargetValue], "#00B050", "#FF0000")Set up the 'Fill Color' in Format Pane with this Measure as Field value.
Thanks much, works great!
Hello @Russo
You’ll need a DAX measure that returns a color name or hex code based on the comparison:
IF([ActualValue] <= [TargetValue], "#00B050", "#FF0000")Set up the 'Fill Color' in Format Pane with this Measure as Field value.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.