Percentage in a 100% bar chart from custom column

[Dan492813]

I have a customer column that gives a TRUE/FALSE result

and

a column that is the total

100 calls created - 25 of these are FALSE

I'm trying to get this into a 100% stacked bar chart to give me the 25% of 100 but it thinks the value total is 125.

Can anyone help?

Thanks, Daniel.

[amitchandak]

@Dan492813 , You should use true/false column as a legend. It will give the correct value.

Also refer https://radacad.com/showing-the-total-value-in-stacked-column-chart-in-power-bi

[ryan_mayu · Accepted solution]

@Dan492813 

Please see if this is helpful.

[Dan492813]

It just seems to give me data like this:

[ryan_mayu]

@Dan492813 

please check if the fields are draged to the correct place.

[Dan492813]

Sorr I was using a field from the wrong table. Your solution works. Thank you!