Power BI- Order Column with Repeative Values

[sheikhbiuser]

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 PositionID
Data is in below format.

How can I sort Position for each Category. ( Position do repeat for Different Category), so that when I put Category in Slicer , and Position in Report, I get Position is sorted Order by every Category Selected in Slicer.

[Daviejoe]

You could create a custom column with the below formula to give you a unique sort/index column

= ([Category ID] * 100) + [Position ID]

[vanessafvg]

you can create an index colum

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

and then sort by id

[sheikhbiuser]

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]

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.  

[sheikhbiuser]

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