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#
Based on your description, you would like to sort text values in the Slicer control. You can click the (...) part to to select Sort By to sort the slicer alphabetically by text values in the slicer.
Sorry did not ask the right way, I need to create a classification of months in the filter object, eg January, February, March ..... and now I can only sort in alphabetical order
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#
Anonymous is absolutely right.
However this only works when the initial column to sort is already of date type. Mine works when the months names are hardcoded and do not come from a date field.
Unfortunately, there is a lot of improvement that has to be made in data types and converting.
