Forum Discussion
Compare Forecast and Actual Date Ranges
I need a visual that compare Actual and Forecast numbers. The data is a table of dates and I have caluclated the DATEDIFF values. Currently I have two stacked bar charts, one for Actual, one Forecast. The problem is that separate visuals distort the scale and occupy too much screen space. Is there a way to create one visual with my data which looks like this (x2)? Thanks!
| Shutdown Start | Shutdown End | Maintenance Start | Maintenance End | Restart Start | Restart End |
| 8/1/2021 | 9/10/2021 | 11/23/2021 | 12/17/2021 | 11/14/2021 | 3/21/2022 |
| 6/26/2021 | 5/25/2021 | 3/16/2021 | 3/4/2021 | 6/23/2021 | 1/13/2021 |
| 8/18/2021 | 10/31/2021 | 3/22/2022 | 5/2/2022 | 1/21/2022 | 10/11/2022 |
| 7/5/2021 | 6/21/2021 | 5/18/2021 | 5/15/2021 | 7/29/2021 | 5/1/2021 |
Hi maranz,
You may try the solution suggested by bcdobbs.
Alternatively, you may also look at creating custom visual specific to your need at the site https://pbivizedit.com
Given the data:
Type Head Days Actual Shutdown 12 Actual Maintenance 9 Actual Restart 4 Forecast Shutdown 12 Forecast Maintenance 13 Forecast Restart 4 I am capable of creating this:
You can have a look at https://pbivizedit.com/gallery/actual-vs-forecast
Please note, these visuals do not support native Power BI tooltips and selection.
Thanks,
-R
4 Replies
Hi maranz,
You may try the solution suggested by bcdobbs.
Alternatively, you may also look at creating custom visual specific to your need at the site https://pbivizedit.com
Given the data:
Type Head Days Actual Shutdown 12 Actual Maintenance 9 Actual Restart 4 Forecast Shutdown 12 Forecast Maintenance 13 Forecast Restart 4 I am capable of creating this:
You can have a look at https://pbivizedit.com/gallery/actual-vs-forecast
Please note, these visuals do not support native Power BI tooltips and selection.
Thanks,
-RHow is the data structured for forecast and actual. If you can get the data into a single table where you can slice by forecast/actual then stacked bars have a "small multiple" option which will do what you want. Just drop the forecast/actual column in there.
Hi, maranz ;
You could create a column or a table So that the values of "actual" and "Forecast" are put into different categories respectively, just like 2013 and 2014 below.
Or could you share simple file and expected result? It makes it easier to give you a solution.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Thank you. This was very helpful.
