Forum Discussion
Gaurav_84
Helper I
Helper IChange in Data colours
Hi Experts, Is it possible to change the data colours based on change in Data numbers. For example i am preparing bar chart where Job "A" have total budget of $10000 the bar is of Green colour. Can w...
amitchandak
Super User
Super UserGaurav_84 , Only if there is not legend and only one measure used you can try conditional formatting using a color measure with field value option
color measure =
Switch( True(),
[Budget] >= 10000, "green"
[Budget] < 0, "red",
"Yellow"
)
Refer
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values