100% Stacked Column Chart % Calculation

Hi irenelitw629 ,

The problem comes from negative values in your data, and if they are all positive, the results are the same on both sides.

Once the negative value of L is added, the result is different.

If you want to keep the results displayed in the left table in the Stacked column chart, you can create the following measure.

Measure = var _sum=SUMX(FILTER(ALLSELECTED(data),[Sales Quarter]=MAX('data'[Sales Quarter])&&[Product]=MAX('data'[Product])),[Sales Amount])
var _all=SUMX(ALLSELECTED(data),[Sales Amount])
return DIVIDE(_sum,_all)

Then use the normal Stacked column chart and replace the original value with a measure, which displays the percentage.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.