Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Power BI- Order Column with Repeative Values

I have 2 Columns, I am able to Sort Category Column by category ID but, Each Category has Position in it, and I also have PositionID against them and wants to sort Position  by Category and PositionI...
Need Help
vanessafvg's avatar
vanessafvg
Community Champion
5 years ago
you can create an index colum

create a new column
id = int(table[category] & table[position])

and then sort by id

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Not very Clear with your solution, Category and Position are text Column ? 
Also Created index Column will not order Position Column in Specific order we want , 

Can you share more detail ,if I am missing anything from ur post?

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    5 years ago

    have you tried to use the calculated column that i suggested?

    Can you specify what you are unsure of? it is not a text column as it is converted into an int, therefore the concatenation of the ids will sort it by number order in the order of the sequence of numbers.  However you will need to put it in your visual.  

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I already Tried same thing (additing column with concat of CategoryID and Position ID  before posting his Question and use this for sorting ,but get error ,Because values like "Manager" and "VP" Repeats in Position Column.


      Some how,I am not able to paste the screen shot ,of error .It says
      " We cant sort the "Position"Columnn by "ID",There cant be more than one value in ID for same value in Position ,Please choose different column"
      Can u try this on ur machine and check on this,Refer my Screen shot ,it has 4 column
      Category,Position,CaregoryID,PositionID