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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

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