Forum Discussion
Date Issue - Calendar Month Year Not populating data
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
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
3 Replies
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.
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
