Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |