Forum Discussion

maranz's avatar
maranz
Frequent Visitor
4 years ago
Solved

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 Foreca...
Need Help
  • radhey_rec's avatar
    radhey_rec
    4 years ago

    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:

    TypeHeadDays
    ActualShutdown12
    ActualMaintenance9
    ActualRestart4
    ForecastShutdown12
    ForecastMaintenance13
    ForecastRestart4

     

    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

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

How 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.