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 PetriR - You can create a calculated column in Power BI that converts all the text to lowercase or uppercase, and then sort your visual based on this column instead of the original text.
Eg: SortColumn = LOWER([YourColumnName]) for Lower for upper you can use it for uniformly set the same.
After creating this column, you can go to the "Sort by Column" option and choose the new column for sorting.
or in Power Query Editor, select the column, then choose Transform > Format > Lowercase or Uppercase.
I hope it works.
Hey, thanks for the fast answer but we don't want to change the data since they are product and service names so they need to retain their capitalization.