Forum Discussion

vivien57's avatar
vivien57
Icon for Super User rankSuper 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 sorti...
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.

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft 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