Column does not sort correctly

[Syndicate_Admin]

I have the OrderMonthName field in the dates table that doesn't sort me correctly. I have this field sorted by the column Month, column that is numeric from 1 to 12

As seen in the capture, first puts April followed by August... This is not the correct order.

Do you know what it can be?

Thank you

[Syndicate_Admin]

Well, what you say is fine, although where it goes wrong is a measure:

The measure looks at year, months and a couple of other fields that I am selecting and shows them to me.

ResumenFiltrosUEstadistica =

var anio = SELECTEDVALUE(Fechas[Año])

RETURN

CONCATENATE("Año: ",CONCATENATE(anio,CONCATENATE(UNICHAR(10),CONCATENATE("Mes: ",CONCATENATE(CONCATENATEX(VALUES(Fechas[NombreMesOrdenado]),Fechas[NombreMesOrdenado],", ",Fechas[NombreMesOrdenado]),CONCATENATE(UNICHAR(10),CONCATENATE("Ambito: ",CONCATENATEX(VALUES(Clientes_sql[Ambito]),Clientes_sql[Ambito],", ",Clientes_sql[Ambito],ASC))))))))

When it shows the result it shows them to me as follows:

[selimovd]

Hey @Syndicate_Admin ,

the order in the filter option is always alphabetical. But in the report it will sort properly.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic