Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

How can I sort the text values in a filter object?

???
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi Anonymous,

     

       as meysun said you have to use "Sort By Column".

     

    1) You have to create two calculated columns ("monthName" and "monthNumber") and visualize monthName as a filter.

     

     

    2) After that you have to select "Sort By Column" and sort by monthNumber, and you gain the result.

     

    Let Me Know If It Works.

     

    #I'M Not An Expert#

sailtango's avatar
sailtango
New Member
8 years ago

I created a calculated column which concatenates month number and month name, and then use that column as a filter:

 

ordered mont = format('table name'[month number];"00") & ". " & 'table name'[month name]

 

 

The Format functiion adds a zero before months 1, 2 and 3, as this column is now a text column.

 

 

Gabriel.