Forum Discussion

Synik_PBI's avatar
Synik_PBI
Icon for Helper II rankHelper II
3 years ago
Solved

Help with sorting a table column text field

Hello! I was hoping to get some thoughts on if I'm missing something when sorting a table column visual. Here is the current sorting structure of the table:  As well as the DAX logic for the R...
Need Help
  • Synik_PBI's avatar
    Synik_PBI
    3 years ago

    Just in case anyone has a similar issue, I solved this problem by creating a new table. 

    Priority Sort Table =

    GROUPBY(
        'Main data',
        'Main data'[Review Priority]
    )

    Then the column that handels the sorting is made like this: 
    SWITCH(
        TRUE(),
        LEN( 'Priority Sort Table'[Review Priority] ) < 3,
        CONCATENATE( "0", 'Priority Sort Table'[Review Priority] ),
        'Priority Sort Table'[Review Priority]
    )
    I then made a relationship on the Review Priority and use the Adjusted inside the visual. 
Synik_PBI's avatar
Synik_PBI
Icon for Helper II rankHelper II
3 years ago

Apologies, but I'm bumping this thread, I'd love either a solution to the sorting issue, or a confirmation and possibly explaination that this is working as intended. Many thanks!