Guidance needed to build a stacked area chart with each set of data is %GT by row.

[AngChuanLing]

Good day, i would like to get help to plot a stacked Line/Area chart in Power BI Desktop, with the data shown as below(In Excel after PIVOT)

Below is the  graph that plotted from Excel. 

But in Power BI(I choose Area Chart), instead of building each CW(as %GT in column Total), 

It only have the option to select "Percent of grand total", but my wish is to arrange the data as column total. 

Am i doing it in wrong way? or Is there any other way? 

Please help me if you have any idea.

thanks,

Ang.  

[amitchandak]

@AngChuanLing , Create a new measure. Assuming your current measure is m1, absolute value []

divide([M1], calculate([M1], removefilters(Table[PlayDay Bin1]))  )

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s

[AngChuanLing]

Thank you @amitchandak , i will try it and update the status soon. 

Thanks a lot.