Forum Discussion
Sort by another column
Maz_0102 , [Stage] is blank for all four, but each has a different Rank (1, 2, 3, 4). So the single Stage value blank maps to four different Rank values → Power BI refuses, because it wouldn't know which rank to sort blank by.
Option 1: If Category is unique so instead of Stage, use the Category column
Option 2: Merge Category and Stage and then apply sort
Hi Maz_0102 ,
The problem is on the rnak 1 to 4. The first question is that when you have blank values you cannot sort the column because the blanks are not recognize, in second place since you have the same value (in this case blank) with different rank that cannot also be done you need to have distinct values for each value in the stage column.
What you can do has a workaround is to paste an empty carachter for each of the ID were you want to have blanks basically repeat the empty character the number of times of your ID then you should be abble to do the sorting.
You would have the following
1 - EmptyChar
2 - EmptyCharEmptyChar
3 - EmptyCharEmptyCharEmptyChar
4 - EmptyCharEmptyCharEmptyCharEmptyChar
This would should has blank but in reality you will have some characters there.
Copy the empty character from the link below.