cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cmd15
Frequent Visitor

Sorting Day/Month Chronologically (Past X Days)

Hi,

Is there a way that the dates can be sorted chronologically with this visual where dates are being shown in Day/Month format?
The issue occurs when traversing dates from last year to this year (e.g. getting last 30 days).

cmd15_3-1642401516996.png

From above example, correct order is from 19/12 to 17/01. 

I can't sort by a custom column Year-Month-Day because I will have multiple values of these for the same Day/Month value.

cmd15_2-1642401376346.png

 

 


Thanks!

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@cmd15 the one way you can do this is, change your day/month column to date (maybe last or first date of the month) and make the custom format string to as dd/mm, it will take care of the sort issue, the display will be dd/mm but internally it will be date and will sort out correctly.

 

 

Follow us on LinkedIn and YouTube.gif to our YouTube channel

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

7 REPLIES 7
parry2k
Super User
Super User

@cmd15 I did a video on something similar a few days ago 🙂

 

Anyhow glad you have a solution. Do join my youtube channel, (line below) where you will find interesting power bi related videos. cheers!

 

 

Follow us on LinkedIn and YouTube.gif to our YouTube channel

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





parry2k
Super User
Super User

@cmd15 doesn't matter if it is in a list or not, you can manually add it as a format string

 

 

Follow us on LinkedIn and YouTube.gif to our YouTube channel

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





cmd15
Frequent Visitor

Thank you ! It worked. It was my first time using Custom Text Format too!

parry2k
Super User
Super User

@cmd15 the one way you can do this is, change your day/month column to date (maybe last or first date of the month) and make the custom format string to as dd/mm, it will take care of the sort issue, the display will be dd/mm but internally it will be date and will sort out correctly.

 

 

Follow us on LinkedIn and YouTube.gif to our YouTube channel

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





cmd15
Frequent Visitor

Hi @parry2k !

Thanks for responding! However, I couldn't find a dd/mm in the list of date formats.

cmd15_0-1642474210056.png

Should I change the data type to Date?


Thanks!




mahoneypat
Microsoft
Microsoft

Have you tried adding your Year-Month-Day column to the tooltips area and then using it to sort the visual (click ellipsis on visual and change sort)?

 

Which visual is that? Dot Plot?


Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


cmd15
Frequent Visitor

Hi @mahoneypat !

It's a scatterchart. I tried adding the field in tooltips but it's not working.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors