Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
@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
Yes, you can use conditional formatting. This should help you.
@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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |