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
We are applying conditional formatting feature for some of our measures.There for a particular range of value say 0 to 85,
as colour move towards extreme we are getting gradient in colour.Is its possible to turn off gradient in conditional formatting?
Any help will be much appreciated.
Thanks,
Saranee
Solved! Go to Solution.
Currently, we can only get gradient in colours. In your scenario, you need to turn off gradient in colour, so you only need two colours in your column? Here is workaround for this requirement, please refer to the link below.
https://community.powerbi.com/t5/Desktop/Conditional-formatting-based-on-dynamic-values/m-p/177823#M...
If this is not what you want, I am afraid there is no other approach to work around this requirement, thank you for your understanding.
Regards,
Charlie Liao
Currently, we can only get gradient in colours. In your scenario, you need to turn off gradient in colour, so you only need two colours in your column? Here is workaround for this requirement, please refer to the link below.
https://community.powerbi.com/t5/Desktop/Conditional-formatting-based-on-dynamic-values/m-p/177823#M...
If this is not what you want, I am afraid there is no other approach to work around this requirement, thank you for your understanding.
Regards,
Charlie Liao
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.