using own calendar linked to another table

[Anonymous]

Hello!

I'm struggling with this issue right now and hope I can get help please.

I made a calendar table in powerbi with dax like below

Calendar = ADDCOLUMNS(

Calendar("2018-01-01",NOW()),

"YearMonth", Format([Date], "YYYY-MM"),

"Year", Format([Date], "yyyy"),

"Quarter", Format([Date], "Q") & "Q",

"MonthNo", Month([Date]),

"Month(EN)", Format([Date], "mmm"),

"Month", Format([Date], "mm"),

"Day", Format([Date], "ddd"),

"DayNo", WeekDay ([Date],2))

and wanted to link the date data from the MySQL DB like below

and made a relationship like below too.

so I thought it's available to make time series chart but it shows like this

I guess some data format or linking issue but I tried several options but didn't work

could you guys give me a hint for this?

[v-yangliu-msft]

Hi  @Anonymous ,

Change the date hierarchy to date.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Some dates are missing, as you can see blank, check that. Use date from the calendar and use axis type as continuous

[Anonymous]

Thank you @amitchandak 

But after i changed the type to continuous.

it shows like this.. 😢