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
Super User
Super User

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
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

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