Forum Discussion
Power BI Number Ordering Problem (1, 10, 11, 12)
My data set has a value of Set=1, Set=2, etc. I split the column by the delimiter "=", and now have one column that has "Set" and the other a Whole Number Value. The whole number is now ordered ...
Hey,
in your model, mark the column that contains "Set 1", "Set 10", "Set 11", ...
In the Data View - Select the menu Modeling - (1) Mark the Column you want to sort - (2) from Sort by Column - (3) Select the column you want to use as SortIndex
Hope this helps
Regards
Thanks. This worked, but I have one question.
For me to achieve the proper ordering, I sorted by the column that is formatted as a whole number.
In essence, I needed to create a column to refernce so that I could have the proper "Sort By". Is this typical?
TomMartens
Super User
Super UserHey,
yes whenever you want or have to change the default ordering you have to create a reference column, eg a column called MonthName.
Regards