How to make different year different color

[admin11]

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 :-

https://www.dropbox.com/s/viufpu6mii49nf5/PBT_V2021_392%20TI_SI_GL%20SAMPLE%20-%20diff%20yr%20diff%2...

Paul

[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

[amitchandak · Accepted solution]

@admin11 , Try a color measure like

Switch(max('Date'[year]),
2019, "green",
2020, "blue",
2021, "red",
"grey"
)

[admin11]

@amitchandak 

Where should i insert the measure to ?