Forum Discussion

vivien57's avatar
vivien57
Super User
5 years ago
Solved

Wrong sorting: Stacked Column Chart

Hello everyone,

I don't understand a behaviour of PowerBI.

I have a Stacked Column Chart that has a bad sort (due to a many to many relationship)

You can see in several places that the sorting is bad. Let's take for example the case of India and Sweden.

If I remove the legend axis, we can see that Sweden has a higher number than India.

However, this is no longer the case when I use the legend axis (as the many-to-many generates more cases for India, but the sorting is not updated accordingly).

 

Do you have an idea?

 

Thanks in advance for your help,

 

Vivien

 

Need Help
  • vivien57's avatar
    vivien57
    5 years ago

    I think I have found a workaround: sort on the one column which is the concatenation of the 2 fields.

    I'm still doing tests and I'll keep you informed.

4 Replies

  • vivien57's avatar
    vivien57
    Super User
    5 years ago

    I think I have found a workaround: sort on the one column which is the concatenation of the 2 fields.

    I'm still doing tests and I'll keep you informed.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      vivien57  Can you expand more on this solution- I am having a similar issue where I can't figure out what my stacked chart is filtering on. It should be defect percentage (longest to smallest line). Any thoughts?

       

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    If that doesn't work, you can make a measure that CALCULATEs the SUM after you REMOVEFILTERS from the legend column, add that to the visual as a Tooltip and Sort by it in the visual.

     

    Pat

     

  • vivien57's avatar
    vivien57
    Super User
    5 years ago

    Hello everyone,

    The concatenation works well.

    Have a nice day,

    Vivien