How to custom sort in a line graph when using percentages.

[John_V12]

Hi all, I have an expression to see the percentage NetWeight per Size in a line graph. 1. Net Weight = SUM('Table'[NetWeight]) as expression 1 2. All Net Weight = CALCULATE([Net Weight],ALL('Table'[Size])) as expression 2 3. % Net Weight = DIVIDE ( [Net Weight] , [All Net Weight] , 0) as final expression to use in line graph. This works 100% as intended, but the moment I try and custom sort the my column with a RELATED column from another table, the results turn from individual percentages to 100% for all columns. What am I missing? Thanks,

[John_V12 · Accepted solution]

Hi all, 

I found a post which solves my problem.

I added a variable and the final expression is as follows:

% Net Weight = VAR _Sort = SELECTEDVALUE('_Final Data 2015-2021'[CountFinal]) Return

DIVIDE ( [Net Weight] , [All Net Weight] , 0)

Thanks,

[V-lianl-msft]

Thanks for your sharing.This may help people who encounter the same problem.