Change in Data colours

[Gaurav_84]

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 we change bar coulor if there is change in amount. For exmple if amount is in negative then bar should turn to "RED" & amount is still in positive but less than $10000 colour should be Yellow.

Regards

Gaurav

[amitchandak]

@Gaurav_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-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[MattAllington]

Yes, you can use conditional formatting. This should help you. 

https://exceleratorbi.com.au/?s=Conditional

[Anonymous]

@Gaurav_84 - You can use conditional formatting to achieve your requirement. Check the below link

https://docs.microsoft.com/en-us/power-bi/visuals/service-tips-and-tricks-for-color-formatting

Appreciate your kudos!! Mark this post as solution if this helps.