Forum Discussion
Stacking values in a report
Hello,
I'm building a report with my bank expenses where I have something like this per month:
Salary 100
Restaurant -10
Supermarket -15
Travel -20
I would like to build a graph where I could see how much I spend per category and my savings, so 100% would be my income in that month and the column (or pie chart) would be subdivided like this:
Restaurant 10
Supermarket 15
Travel 20
Savings (salary - all expenses) 55
I can get the savings, but I cannot stack all together. Would you have an idea on how to do this?
Many thanks, and have a great start of the year!
4 Replies
Cienfu , The information you have provided is not making the problem clear to me. Can you please explain with an example.
refer if this visual can help https://github.com/microsoft/charticulator/issues/219
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart
Appreciate your Kudos.Hi, thanks for your answers, I add a picture that will clarify, but if you have similar ideas, I'm open to listen!
The 100% of the column is what I get as income, and the column is subdivided in all the expenses. Sadly it happens sometimes that the income is lower than all the expenses (March)
Data is the following:
Expense Ammount Date
Salary 100 January
Restaurant -10 January
Supermarket -20 January
Travel -20 January
Salary 110 February
Restaurant -20 February
Supermarket -20 February
Travel -30 February
Salary 90 March
Restaurant -30 March
Supermarket -40 March
Travel -50 MarchThanks!
Hi Cienfu ,
Based on your description, I did a test. Is the following result you want?
Best Regards,
Yuna
