Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
CAmala
Frequent Visitor

Custom Order in every Legend

Hi everyone

I need your help, please.

 

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

CAmala_2-1674604073090.png

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

CAmala_0-1674604963295.png

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

 

CAmala_2-1674605093085.png

 

Thanks

Camala

1 ACCEPTED SOLUTION
adudani
Super User
Super User

@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

 

 

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a Kudos 🙂
Kind Regards,
Avinash

View solution in original post

2 REPLIES 2
adudani
Super User
Super User

@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

 

 

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a Kudos 🙂
Kind Regards,
Avinash

Thank you @adudani it was so helpful

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.