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
You can change how a column sorts by going to the Modeling tab. So, for a given column, you set it to sort by another column. In your case, select the "Set 1, Set 2, Set 3, etc." column, go to Sort by Column and select the "Number" column.