Forum Discussion
Solved
Sort by another column
Hello can please someone advise what I'm doing wrong here my table has no duplicates i am trying to sort the stage column by rank 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
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