Monthly Bar chart how to set X axis bar color before COVID yellow color ?

[Paulyeo11]

Hi All

[mahoneypat]

To do this, make a measure like this

Bar Color = IF(MAX('Date'[Date])>=DATE(2019,1,1), "Green", "Yellow")

Then on the format options for your chart on Data Colors, hit the "fx" button, pick Field Value and the above measure (modified with your threshold date and colors).  This is what the above looks like in a chart.

Regards,

Pat

[Paulyeo11]

Hi Sir

Thank you very much for sharing , kindly help me set up by make those 4 bar which only after Feb 2020 is blue color the rest yellow color. ( i have try to so it myself , i cannot figure out where to paste your expression )

https://www.dropbox.com/s/8sdwhpjxced7wqn/preWebinarPostCal_PY_DATA%20V008%20Working.pbix?dl=0

[manikumar34 · Accepted solution]

@Paulyeo11 

You can use the Same DAX and in data colors use the field value to change the color. 

https://www.dropbox.com/s/3paix06o82v3fob/preWebinarPostCal_PY_DATA%20V008%20Working.pbix?dl=0

Uploaded here.

Regards, 

Manikumar

[Paulyeo11]

Hi Mani

Thank you vry much , finally i know where to link the Bar color field. now it work fine.

[manikumar34]

@Paulyeo11 ,

Awesoem, I am happy for you. You got the answer. Keep in touch.

Follow me on LinkedIn

Regards, 
Manikumar