Date Issue - Calendar Month Year Not populating data

[Anonymous]

Hi Experts

See attached sample file, when you change the filter on the Calendar to Month Year (from Date Hierarchy to Calendar month year) - shared axies you get a Flat line in the ploted Line Bar Chart, If you add all periods it works fine, the issue is drilling down to year month level.

Sample File
https://www.dropbox.com/s/d8aljd4zxih0w2d/Test%20%281%29.pbix?dl=0 

[mahoneypat · Accepted solution]

It is good that you have a dedicated Date table in your model, but you also need to turn off Auto Date/Time in the settings for the file.  The issue is that your Calendar table is not "Marked as a date table".  Also your Date column is DateTime type instead of Date.  Once you fix those, the chart looks the same.

Pat

[Anonymous]

Thanks Pat excellent feedback, Fixed

[amitchandak]

@Anonymous , I found few relationship issues. I saw that join of the date table is with moth year, not on date. Which I think is not correct.