Forum Discussion
Analyze - Explain Increase now missing
Thanks for your response tmack99
The only major difference I can think of is that I changed the source of my default 'date' column. I was using an excel table (with a one column of dates) but have since moved to =calendar dax as shown below.
The X axis then uses the 'MMM YY' column however it did before when it worked so I'm struggling to understand what has changed (sorry, I'm still a novice!)
The CALENDARDAX function automatically creates a date column based on the specified range. This means that the column will update itself as you add more data to your model. It is unlikely that the 'MMM YY' column is causing the issue, because this feature uses statistical analysis of variables, not the format of the X-axis.
Another possibility is that some of your data is missing, which could be why the statistical analysis isn't working. Make sure all your data is there and there are no blank spaces or null values for the field you're using on X-axis. Also, check that the X-axis isn't generating any errors.
It's hard to say exactly what's causing the problem without more information about your data and what specific steps you took when implementing