Stack Barchart Total and Part

[spagad6263]

Hi, I would like to create a chart, which shows Total Amout and Percentage of Amount Paid. Below is the first-cut but it shows [Total Amount] and [Amount Paid] as separate part of the bar.

Is there a way to show the whole bar as [Total Amount] and the green bar as [Amount Paid]? Thanks

[Prateek97 · Accepted solution]

Hi @spagad6263 ,

You can create another measure which will have the difference of [Total Amount] and [Amount Paid]. Then add this difference measure and Amount Paid measure in the bar chart. It should work.

If it works for you, please mark this as accepted solution.

[spagad6263]

It's kind of working, but not quite what I want. Any other suggestions?

[Prateek97 · Accepted solution]

Hi @spagad6263 ,

May I know what is it that you are looking for exactly which the suggested way is not solving?

Sorry, but I am not not able to understand the requirement I guess.

[gvlado]

To see on stacked barchart total of segments you may use "Total labels" ( i use PBI Upgrade december 2023)

[spagad6263]

Thanks for the quick reply. I will give it a go. Thanks

[Prateek97 · Accepted solution]

Hi @spagad6263 ,

You can create another measure which will have the difference of [Total Amount] and [Amount Paid]. Then add this difference measure and Amount Paid measure in the bar chart. It should work.

If it works for you, please mark this as accepted solution.