cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Creating a Pie Chart comparing amount spent vs Amount left

Hey guys I am completely blanking out on how to set up this simple pie chart. Basically I have 2 accounts, and I want 2 separate Pie charts for each account that shows the total amount spent vs the amount left in the budget. Where the whole graph represents the full budget. I have all these measures I created for other visuals that give me that information, but I am not sure how to make it work with the pie chart. Here are some pictures to help visualize what I am trying to do.

E6.jpgE7.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
diogoblunck Regular Visitor
Regular Visitor

Re: Creating a Pie Chart comparing amount spent vs Amount left

Hello again!

 

Thx for the reply. Its easy to see data!

You need to make a option:

1 - Create a Column to bring the difference between Total Budget and Spend, that way you will get Two Facts Columns: One with the spend amount (I belive that is the AMOUNT column in the first pic) and another with the calc maked above.

Put the two columns in your pie chart and the magic goes on.

 

2 - Create a new table (virtual or not) with the summarize of the same two columns: Amount and (Total Budget-Amount), and put this tabel inside a SUMX measure.

Put the two columns in your pie chart and the magic goes on.

 

See the sample in the follow link: https://rebrand.ly/n6o0o8

 

View solution in original post

4 REPLIES 4
Highlighted
diogoblunck Regular Visitor
Regular Visitor

Re: Creating a Pie Chart comparing amount spent vs Amount left

Hello,

 

Can you inform with column in your model that separates the amount spend and the bugdet?

With this we can create a simple Calculate measure to make your pie chart possible.

 

Anonymous
Not applicable

Re: Creating a Pie Chart comparing amount spent vs Amount left

@diogoblunck 

Under that experimental budget tab this is what the data looks like. It is very simple. I have a measure that adds them all up because I don't care about budget group for this visual.  In a separate table I have the amount spent. Every month a new file gets added to the folder that contains more data. I have a measure that sums the amount. And a separate measure that subtracts the total budget with amount spent. You can see all of them that I did in the original post. but here are the SS's

E8.JPGE9.JPG

Anonymous
Not applicable

Re: Creating a Pie Chart comparing amount spent vs Amount left

I feel I may have jumped the gun on this post. I figured it out. I just had to create a column with a relationship between the budget and the amount spent. Worked out well. Here is a SS with how I made it look.

E10.JPG

diogoblunck Regular Visitor
Regular Visitor

Re: Creating a Pie Chart comparing amount spent vs Amount left

Hello again!

 

Thx for the reply. Its easy to see data!

You need to make a option:

1 - Create a Column to bring the difference between Total Budget and Spend, that way you will get Two Facts Columns: One with the spend amount (I belive that is the AMOUNT column in the first pic) and another with the calc maked above.

Put the two columns in your pie chart and the magic goes on.

 

2 - Create a new table (virtual or not) with the summarize of the same two columns: Amount and (Total Budget-Amount), and put this tabel inside a SUMX measure.

Put the two columns in your pie chart and the magic goes on.

 

See the sample in the follow link: https://rebrand.ly/n6o0o8

 

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 6 members 3,353 guests
Please welcome our newest community members: