Stacked bar chart won't sort properly with value in legend

[pbakaric]

I'm having an issue with the stacked bar chart. If I insert a value for the legend, then the chart will not sort properly when I select "sort by" from the graphic menu. It seems like the sort does not take into account the impact of the legend value. This seems like this might be a bug? Let me emphasize, I did select "sort by" multiple times but it never orders properly. I expect to Pareto both bar charts (in order of largest to smallest value).

No legend value:

With legend value:

Datasets:

Volume DataDefect Data

Dataset Relationship:

Yield Contributor formula:

Yield Contributor = DIVIDE(SUM(Defect[Count]),SUM(Volume[Count]))

[freyadudding2]

I actually found a solution!

I created a measure that did
CALCULATE(measure, Type = A) + CALCULATE(measure, Type = B) + CALCULATE(measure, Type = C)
Then I added this to the tooltip and sorted by this instead

[freyadudding2]

Only 7 years later but I am having this same issue and cannot find another post to help me find a solution to this! Does anyone know why using a measure and a legend in stacked bar ruins the sort order?!

[v-yulgu-msft]

Hi @pbakaric,

Below is the result in my test, as you can see, the appearance of bar chart and the sequence of sort by are not affected by legend. Also, it is only allowed to sort the chart based on the columns added to Axis and Value, that is to say we cannot sort by legend.

From the two images you post, it seems that the value on X-axis is changed after adding legend. Are the source data the same in these two charts? What do you mean "the sort does not take into account the impact of the legend value"? It is not clear about how you want to sort the chart? Would you please provide more detaied description about your expect result, if possible you can upload your pbix file.

Thanks,
Yuliana Gu

[pbakaric]

Yuliana,

Thank you for the response. How do I upload a file? I don't see an option to add a file. I have created a simplified example to share. I have also updated my original post with that example. 

To quickly address your questions:

1) Yes, the data source is the same in both charts.

2) I expect to show the graphic as a Pareto (order values from largest to smallest)

[v-yulgu-msft]

Hi @pbakaric,

Remove the relationship between these two tables.

If you still have any question, please feel free to ask.

Thanks,

Yuliana Gu

[pbakaric]

Yuliana,

The relationship is important and cannot be removed. Your calculated values are not correct with the relationship removed.

Why can the sort not take into account the impact of the legend? The sort order should be determined by the total value for each item. 

Preston

[Thiyags]

@pbakaric

I am able to sort the chart after adding the legends too. 

 

[pbakaric]

Thiyags,

You are not using the measure I listed above called "yield contributor". The calculation makes the defect count more impactful with the lower volume count of C. Your example is not the same and will not show the issue.

Preston