Venkata on 09 Jun 2017 06:12:38
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
Administrator on 03 Jul 2019 03:19:35
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!
- Comments (6)
RE: Conditional Formatting with fixed colors not color scale.
it's nor working when use with multiple value. Anyone has work around with this ?
RE: Conditional Formatting with fixed colors not color scale.
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....
RE: Conditional Formatting with fixed colors not color scale.
I would also recommend this feature,we also have same requirement.
RE: Conditional Formatting with fixed colors not color scale.
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
RE: Conditional Formatting with fixed colors not color scale.
I would also recommend this feature,we also have same requirement..
RE: Conditional Formatting with fixed colors not color scale.
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.