Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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,
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |