Drilling Down Forecast Line Chart Unselects "Continuous" - Removes forecast

[Almizu]

Hello,

I have built a main dataset in Power BI that I am using to feed some other datasets and reports with. I noticed that in the main data set I am able to build a line chart and add in the forecasting tool with my Calendar Dimension table. With this I am able to drill down at the year, quarter and then month level and the report type stays "Continuous" and gives a forecast at each level. 

When I attempt to do the same thing in one of the reports that is tied to this data set, as soon as I drill down past the year level the line chart changes to "categorical" and the forecasting disapears. I have double checked overall report settings and have played around with using a different date table without good results. The thing is that I am currently doing this in a different reporting structure and it works fine with no issues. I cannot seem to find what is causing this. 

I did notice that the X-axis listing on the one that works looks like this:

and the ones that are tied to the main dataset look like this:

The current date table that I am using is the following:

Any ideas or help would be much appreciated!

[Almizu]

One other thing to note here. I tested this again with the following calendar table:

I was able to build a line chart with forecasting and drill down through year to quarter to month. However, as soon as I flipped it to a DirectQuery it would not allow me to drill down in that line chart and still show a forecast. Why would switching to a DirectQuery change that funcitonality and is there a way around it?

[some_bih · Accepted solution]

Hi @Almizu in initital post you did not write DirectQuery 

Check limitation from official ADDCOLUMNS documentation on link

https://learn.microsoft.com/en-us/dax/addcolumns-function-dax?WT.mc_id=DP-MVP-4025372 

Hope this help

[Almizu]

Hello @some_bih 

I tried changing up the VAR days to use CALENDARAUTO and just physically set a start and end date, but I am still getting the same issue. The forecasting function works fine in the main data set, but any other reports that are tied to it will not allow you to drill down past year. 

[some_bih]

Hi @Almizu 

Check your VAR days as you are referencing two different tables

Did I answer your question? Kudos appreciated / accept solution!