March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to Solution.
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.
Hello everyone,
The concatenation works well.
Have a nice day,
Vivien
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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.
@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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
99 | |
88 | |
70 | |
61 |
User | Count |
---|---|
142 | |
122 | |
105 | |
94 | |
90 |