Forum Discussion
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
Anonymous
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
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.