Define additional category for remaining percentages

[chotu27]

HI All,

I have stacked area chart which is showing percentages accross the years.

2018 = 18.50%

2019 = 27.50%

2020 = 33.50%

i need output in graph has

2018 = 18.50%   remaining =81.5

2019 = 27.50%   remaining = 72.5

2020 = 33.50%   remaining = 66.5

[v-yulgu-msft]

Hi @chotu27 ,

Suppose there existing a measure called [Percentage] which returns percentage for each year. To get the remaining percentages, please create an extra measure like this:

Remaining=1-[Percentage]

Best regards,

Yuliana Gu