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 Ba...
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
mahoneypat
Microsoft Employee
Microsoft EmployeeIt 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
Thanks Pat excellent feedback, Fixed