Forum Discussion
Stack Barchart Total and Part
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
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.
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.
5 Replies
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.
Thanks for the quick reply. I will give it a go. Thanks
It's kind of working, but not quite what I want. Any other suggestions?
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.
To see on stacked barchart total of segments you may use "Total labels" ( i use PBI Upgrade december 2023)
