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#
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.
SabineOussi I just saw your solution and I think that it's really great, I've never thought about that.
It can be very helpful!!
Thanks =D works well!!!
Hi, I did that but didn't work for me :(
I have a weekdays slicer and tried the same..I created a column of week days numbers and sorted by it ....it did sort the table but nothing changed on the report page the slicer is sorted alphabetically
Help Please !!!!!
Bue dia solicito su ayuda en lo siguiente
Necesito mostrar un grafico de columnas de forma ordeanada, tengo datos agosto- diciembre 2017 y enero 2018, al graficar, no se organiza la infmoación de forma cronologica. Ya ordene los datos en la data pero en el reporte no quedan organizados
I have a chronologically ordered data record, and I already ordered the original database, I have data for the August-December 2017 and January 2018 periods
,
I have a chronologically ordered data record, already sort the original database, I have data for the period August-December 2017 and January 2018, when inserting a graph of columns the months are displayed in a disorderly manner, the data for January are shown 2018 in the middle of the graph, when they should appear at the end. I appreciate your help
Thanks its worked for me.
Regards,
Srinivas.
