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
amitchandak
Super User
Super UserAnonymous , 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.