Forum Discussion
How can I sort the text values in a filter object?
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#
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.
Hi,
I've made the same comment on a different similar topic:
In my case I have color states: red, amber, yellow, green. I've created a calculated column with an IF function; IF color sates = "Red" then "A", then "B", then "C"... Now I click on color state/Modelling/Sort by column and click on my new calculated column. But it gives back the following message: "This column cant't be sorted by a column that is already sorted, directly or indirectly, by this column."
Any tip?
Thanks in advance!
