Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 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 ...
Need Help
Show and Tell
Tips and Tricks
  • TomMartens's avatar
    TomMartens
    9 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

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
9 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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

TomMartens

 

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's avatar
    TomMartens
    Icon for Super User rankSuper User
    9 years ago

    Hey,

     

    yes whenever you want or have to change the default ordering you have to create a reference column, eg a column called MonthName.

     

    Regards