Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Conditional Formatting with fixed colors not color scale.

Hi Team, Conditional formatting is extremely poor as it does not satisfy the basic criteria. I need to set the colors based on the value ranges. Red - if the values are <75 Yellow if the values are in between 75 and 84 Green if >=85. I don't need diverging. Users are getting confused among the multiple shades when you are dealing with high dense values. Please let me know if this can be implemented in the near future or not, Thanks KVB
Status: Completed
Comments
nishalit
New Member
This is available through conditional formatting. https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting shows how to do it in a table, but it works for chart colors as well. Thanks!
mahimas
New Member
This is a requirement for a lot of our projects. I like the gradient feature, but we should be able to select at least 3 fixed colors.
Srilakshmi_C
New Member
I would also recommend this feature,we also have same requirement..
jannick_finne
New Member
I have done it like this within a table. I would however like to do it i more of the visualisations. https://prnt.sc/hmvwkn
vedansh_mishra
New Member
I would also recommend this feature,we also have same requirement.
nish2288
Helper I
Its very basic feature which should be there. It should be allowed to use expression at other field as well instead of hard coded values for example: Constant line Waiting for this feature....
manutdever
New Member
it's nor working when use with multiple value. Anyone has work around with this ?
fbcideas_migusr
New Member
Status changed to: Completed