Is it possible for powerbi date bar graph each month represent a different measure

[Anonymous]

As stated in the subject. 

I have multiple extraction data dates, which means the datas are about the same but the extraction date differs.

I want to have a date visual based on some calculation in each data extraion dates and put that number in each the data extraction month in the date bar grap. Is it possible? how?

Thankyou!

[amitchandak · Accepted solution]

@Anonymous , I am assuming you have common date table and date tbale is used on the axis. You can use logic like

Switch(Max(Date[Month]) //or use month year, I am using month no

1, [Meausre 1],

2, [Meausre 2],

//Add others

12 //default value

)

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56

IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM