Forum Discussion

FalconBudget's avatar
FalconBudget
Frequent Visitor
7 years ago

Line graph with two time markers

I am working on a budget vs actual reporting dashboard. We do monthly planing, so we want to be able to see how the whole year is planned out (ie there may be a planned spike in November) but only want to see the actuals up to the selected month. I have every other visualization interact with the month & year drop down, but if I do so for the line graph I just have two dots.

 

Is there a way to have the budget show for the entire year but limit the data shown for actuals? Without the beforementioned limitations, there are financials posted to months that haven't closed yet, causing issues like below where they have negative expenses for March, which is not true.

Budget (black) needs to show 12 months of projection where Actuals (green) should only show up to the month selected

 

Here is how our old graph looked in excel:

Old excel graph (it ends at selected month)

And the work around with a separate hidden pivot chart; essentially erroring out the actuals after the selected month:

 

Thank you!

 

FalconBudget

4 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee

    Hi FalconBudget ,

    Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

     

    Regards,

    Daniel He

    • FalconBudget's avatar
      FalconBudget
      Frequent Visitor

      Howdy, this has not yet been resolved. The answer you posted was interesting but not quite what I was looking for. I am going to keep trying different things. 

      • v-danhe-msft's avatar
        v-danhe-msft
        Microsoft Employee

        Hi FalconBudget ,

        Ok, if your problem could be sloved, don't forget to close this topic.

         

        Regards,

        Daniel He