Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 ...
  • TomMartens's avatar
    8 years ago

    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