Forum Discussion
Synik_PBI
Helper II
Helper IIHelp 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...
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:I then made a relationship on the Review Priority and use the Adjusted inside the visual.SWITCH(TRUE(),LEN( 'Priority Sort Table'[Review Priority] ) < 3,CONCATENATE( "0", 'Priority Sort Table'[Review Priority] ),'Priority Sort Table'[Review Priority])
Synik_PBIHelper II
Helper IIJust 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:
I then made a relationship on the Review Priority and use the Adjusted inside the visual.
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]
)