Custom Order in every Legend

[CAmala]

Hi everyone

I need your help, please.

In this table, columns Id_contable and IdCont_mes are set to Sort by secuencia.

If I change month by Id_Contable the order is that I want it.

But when I use the month column, the chart shows another Order. How can I order in Sep, Oct, Nov, Dec, Jan, Feb?

Thanks

Camala

[adudani · Accepted solution]

@CAmala ,

create a month sort column ( example:SWITCH (TABLE[MonthColumn], 1, Sept, 2, Oct , etc)   whatever sorting order you want)
in the data view, select the month column and use the "sort by column" to sort by this custom column.

for reference: (146) Power BI - Custom Sorting in 3 Easy Steps! - YouTube

here they sort using a table but you can sort using a new column as well.

Appreciate a thumbs up if this is helpful.

Please let me know if this resolves the question

[CAmala]

Thank you @adudani it was so helpful