Forum Discussion
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).
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.
Thanks!
Anonymous 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 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.
7 Replies
- parry2k
Super User
Anonymous 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 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.
Hi parry2k !
Thanks for responding! However, I couldn't find a dd/mm in the list of date formats.Should I change the data type to Date?
Thanks!
- parry2k
Anonymous 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 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.
- mahoneypat
Microsoft Employee
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?
PatHi mahoneypat !
It's a scatterchart. I tried adding the field in tooltips but it's not working.
- parry2k
Anonymous 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 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.
