Bar chart of part to a whole

[Ajax]

I have an excel sheet of people who owe debts. A column for their names, another column for the amount of debt each owed, and another column for how much of the debt they have paid off. Now, I want to do a stacked bar chart depicting the amount paid by each person as a green bar and the amount remaining in each person's indebtness as a red bar. How do I this without creating a different column for the amount remaining?

[Ashish_Mathur]

Hi,

These 3 measures should work

Amount owed = SUM(Data[Amount owed])

Amount paid = SUM(Data[Amount paid])

New amount owed = [Amount owed]-[Amount paid]

Hope this helps.

[mwegener]

Hi @Ajax 

why don't you want to create another column?

Would measures be okay?

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[Ajax]

Thanks mwegener for your response. The reason I don't want to create another column is that I don't want to have to modify my table every time that I need to update my visualizations that are based on it.

[mwegener]

Hi @Ajax ,

but you can use a Calculated Column in Power BI for that.

'Table'[balance] = 'Table'[amount debt ] - 'Table'[amount paid]

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[mwegener]

Hi @Ajax ,

is your problem solved?
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.