Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AJP-PBI
Helper I
Helper I

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

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.

 

AJPPBI_0-1668757458404.png

 

 

Regards,
AJP

1 ACCEPTED SOLUTION
AJP-PBI
Helper I
Helper I

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

 

Regards,
Aditya

View solution in original post

2 REPLIES 2
AJP-PBI
Helper I
Helper I

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

 

Regards,
Aditya

MahyarTF
Memorable Member
Memorable Member

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 :

MahyarTF_0-1668758576411.png

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

MahyarTF_1-1668758629388.png

I sorted the column based on the Date column now :

MahyarTF_2-1668758667723.png

Now the visual is sorted automatically :

MahyarTF_3-1668758693015.png

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

Mahyartf

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.