Forum Discussion
Change 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 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
3 Replies
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-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-valuesGaurav_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.
Yes, you can use conditional formatting. This should help you.
