How to Sort days of month chronologically when months are drilled down to days?

[Anonymous]

Hello Data Enthusiasts,

I want to sort the days of the month Chronologically. When I am drilling down Months to days, Day entries get randomly placed in the chart. I have attached the Screenshot. I want to Sort it for every month starting 1,2,3,4.....30/31. 
Currently, they are randomly placed.

Kindly help me out.

Regards,
AJP

[Anonymous · Accepted solution]

Hello @MahyarTF 
Thanks a lot for the solution. It worked. 

Regards,
Aditya

[MahyarTF]

Hi,

In my opinion, you need to sort the particular column based on the other column, if you have any column that is as a 'Day of year' or Date column, sort the 'month-Day column based on one of those columns.

For instance, I have below table :

As I create visual, it shows the below one (not sorted) :

I sorted the column based on the Date column now :

Now the visual is sorted automatically :

Appreciate your kudos and please mark it as a solution if it helps you