% Sales Share per Customer Type per Year

[Anonymous]

Hi,

I'm struggling to create a measure that will allow me to display the data in the same format as the picture below

each bar shows the percentage sales share for that customer type (plat, gold, bronze, silver) in a given year.

All the formulas I've come up with only give me a percentage of the grand total. 

Any help or guidance would be much appreciated!

[tangutoori]

PLEASE SHARE DATASET

[v-chuncz-msft · Accepted solution]

@Anonymous ,

Here are two examples.

• https://community.powerbi.com/t5/Desktop/Percentages-to-multi-line-report/m-p/378504#M172040
• https://community.powerbi.com/t5/Desktop/Subtotal-Percentages/m-p/313658#M139139