Forum Discussion
PowerBi gantt sorting bug
Hi,
Thanks for solution rajendraongole1 offered, and i want to offer some more information for user to refer to.
hello PetriR , based on your descriotion, please check that if you sort it descending, if it is sorting descending, it will sort befoe the "ebikes".
And you can try to remove the visual, then recreate it and sort the field.
After tesing, it can work in my sample.
If the soution above cannot solve it, you can consider to add a custom column in power query.
=Text.Upper([Column1])Then in power bi desktop, select the column1 and the select sort by the custom column.
Then remove the field in visual and reput it to the visual, it should work.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for solution rajendraongole1 offered, and i want to offer some more information for user to refer to.
hello PetriR , based on your descriotion, please check that if you sort it descending, if it is sorting descending, it will sort befoe the "ebikes".
And you can try to remove the visual, then recreate it and sort the field.
After tesing, it can work in my sample.
If the soution above cannot solve it, you can consider to add a custom column in power query.
=Text.Upper([Column1])
Then in power bi desktop, select the column1 and the select sort by the custom column.
Then remove the field in visual and reput it to the visual, it should work.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply but the data is sorted correctly in the table view but not in the gantt chart. The structure in the gantt is so that there is one data field which categorizes these fields which are not sorting correctly therefore they are not in the "top" level but in the second. So if I remove the top level categorization the sorting works.
Hi PetriR
Thanks for your quick reply, can you provide the picture to show the problem you faced, and hide the private information.
Best Regards!
Yolo Zhu
I hope you can see here based on the first letters and see the structure. If that narrowing with on field which creates the "+" hierarchy is removed, the sorting works. Therefore it seems like a bug.
Hi PetriR
You can use the solution i offered, in power query create a custom column to upper the text, then in desktop select the column and sort by the cutom column, you can refet to the 4th meassage.
Best Regards!
Yolo Zhu