how to use stacked chart

[jjmao]

hi everyone

I have question here, sorry if it sound simple but I couldnt get it fixed.

I have table visual below & would like to use a 100% stacked chart.

https://1drv.ms/u/s!ApEx5aVi8GOXahNB06awZetSVPk?e=y7cHBp

Thank you all for the help!

[TomMartens · Accepted solution]

Hey @jjmao ,

this is not how the 100% chart types work, the values you are using are considered forming the total, this means that the 1 who visited the store represents a third and not one of 2, meaning 50%.

For this reason, you have to create a measure that represents the remaining part of the group. From the sample you provided I created this simple measure:

the other part of the group = 1 - [% of group] 

If, I'm using both measures on the 100% bar chart it will look like this:

Hopefully, this provides some ideas on how to tackle your challenge.

Regards,

Tom