Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Issue with Donut chart when sorting by column code

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

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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