The solution is far easier than I thought.
Thank you ,
I have quick question. sorting is working fine in Power BI Desktop version. when i publish to power BI services, it's not shown sorting order
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
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.
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."
Thanks in advance!