Forum Discussion

germanobasler's avatar
germanobasler
Icon for Helper I rankHelper I
9 years ago

Create a Budget chart with buttons (weekly/monthly allowance)

Dear PBI experts, good afternoon.

 

I am trying to create a budget attainment chart, in which the bars will show the budget position cumulative in 2017.

 

It is far from ready now, still lots of database obstacles to overcome, but I already have a question.

 

I´ll put an indicator of how much budget is already spent and would like to subtract it from the total Budget, so this indicator will show how much budget there is to spend.

 

Then, the best part: three buttons: TOTAL / MONTHLY / WEEKLY is allowed to be spend within the next periods to the end of current year to meet the yearly budget.

 

Is this core to Power BI?

 

Thanks a lot,

Germano Basler

Need Help
Tips and Tricks

3 Replies

    • schoudha's avatar
      schoudha
      Frequent Visitor
      8 years ago

      Hi MFeix,

       

      I have same question. I need help in creating measure to show left over budget every month -

      I mean in the starting of year the I have full budget than I want to subtract open commitments of Jan from total and then from remaning budget to subtract feb open commitment and so on till dec and check how much leftover budget I have in the end of the year.

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        8 years ago

        Hi schoudha,

         

        Can you please elaborate on your question and give some example on what you need and how is the expected end result.

         

        Regards,

        MFelix