Forum Discussion
admin11
Memorable Member
Memorable MemberHow to make different year different color
Hi All
I have a bar chart with YrMth , i like to make every year different colour , may i know how to do it ?
Below is my PBI file :-
Paul
admin11 , Try a color measure like
Switch(max('Date'[year]),
2019, "green",
2020, "blue",
2021, "red",
"grey"
)
4 Replies
- amitchandak
Super User
admin11 , Try a color measure like
Switch(max('Date'[year]),
2019, "green",
2020, "blue",
2021, "red",
"grey"
)
admin11
- amitchandak
admin11 , in coditional formatting, Data color , advance option, "Field value" nad use measure
refer my video for this https://youtu.be/RqBb5eBf_I4
- admin11
Thank you very much , it work fine now