Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
germanobasler
Helper I
Helper I

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

3 REPLIES 3
MFelix
Super User
Super User

Hi @germanobasler,

 

This is possible in PBI yoy can do the measures to calculate the TOTAL /MONTHLY / WEEKLY  and then use a slicer to change between the 3 in your visuals.

 

Check this link to help you http://community.powerbi.com/t5/Webinars-and-Video-Gallery/Turn-Measures-On-and-Off-Inside-a-Chart-w...

 

If you need further help please tell

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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.

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.