Analyze - Explain Increase now missing

[Ade108]

Hi all,

I've been using the 'analyze - explain the increase' frequently in my new dashbaord and it's one of my most useful features. Rather worryingly though I've noticed it's now not available and I can only see 'find where distribution is different'.

The only change I have made recently is I've updated the X-axis with dates from a new calendar table as mentioned in my last post here. 

Solved: Parallelperiod -1 showing values from -3 months ag... - Microsoft Power BI Community

Can anyone please help why this is missing? I've read the exclusions on when this function won't work but I'm still unsure why I could use it before I updated the X axis.

Thanks

[tmack99]

Your previous use of the increase function was probably a result of the fact that your X-axis contained a certain set of dates. My guess is the increment functionality ceased to function when you updated the X-axis with new dates from a new calendar table because it was unable to recognize the new dates. Make sure the new dates are formatted appropriately and that they fall inside the same date range as the original X-axis in order to resolve this problem. To make sure that the increase feature is correctly recognizing the new dates, you might also need to change its parameters.

this feature is only available when the following conditions are met:

The data is a time series.
The data is continuous (not discrete).
The data is numerical.

[Ade108]

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!)

[tmack99]

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

[Ade108]

Thank you @tmack99 , will take a deeper look based on your advice