Issue with Donut chart when sorting by column code

[Anonymous]

Hi everyone,

I'm having trouble when drawing Donut chart with the legend sorted by another column code.

I'm trying to calculate the Percentage Contribution of Volume (kind of sales number) by Channel with the formula as below

Then I wanted the legend Channel to be in order, so I use another Channel.Code column and sort Channel by Channel.Code. When I drew a Donut chart for this, the chart became like below. It divided the chart into 7 equal parts, not the real contribution by each channel. Did I do any wrong steps? Thank you in advance

[Anonymous · Accepted solution]

Thanks for your support, I had mistakes in the formula, I fixed it already

[amitchandak]

@Anonymous , can you check in a table visual, how near these values are. Also, Mark the column as % column in the measure tools.

I am assuming what I am seeing is the measure, no column.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.