Forecasting Feature | Displaying Visuals Using a Different Time Series Category than the Model

[petrenkw]

Hi,

Is it possible to model a forecast based on 1 time series category (days), but display the forecast visuals in another time series category (months) to essentially summarize a forecast? (using the time series days, in my case, yields the most accurate model)

In the example below, I'm forecasting revenue for the remainder of the year based on the fiscal reporting week. Instead of displaying the trends by week, I'd like to display them by month to give our partners a summary of the forecast.

My current chart is below

But I'd like to reformat it to something that looks like the following:

Perhaps there's a way I can do this already? 

I appreciate the help!

[v-sihou-msft · Accepted solution]

@petrenkw

It's not supported to directly get the data within Power BI Desktop. But you can export data to CSV file from the chart visual. It will keep the ForecastValue. 

Then you can import this CSV into Power BI Desktop, and join it into your existing table. 

Regards,