Sorting Day/Month Chronologically (Past X Days)

[cmd15]

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!

[parry2k]

@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  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.

[parry2k]

@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  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.

[cmd15]

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

[parry2k · Accepted solution]

@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  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.

[cmd15]

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!

[mahoneypat]

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

[cmd15]

Hi @mahoneypat !

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