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

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

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.

 

maranz's avatar
maranz
Frequent Visitor
4 years ago

Thank you.  This was very helpful.