Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I've created a day-month column using the short month name, and day of the month number in my dataset to obtain the following format dd-ShortMonthName, e.g. 01-Sep, 02-Sep...10-Dec etc. How can I order this column so that it on a line graph, it starts with the earliest date first?
Many thanks,
afk
Solved! Go to Solution.
Hi @bo_afk
I think you should create a column like MMDD like 01-Jan, 02-Mar would be 0101, 0302, That will sort on month and date.
What you need is a numeric column to use as the sort order.
MonthDaySort = MONTH ( uvw_RescoMobileAudit[Created On] ) * 100 + DAY ( uvw_RescoMobileAudit[Created On] )
Then you set the sort on the Month/Day to use MonthDaySort. In the image below I am setting the sort order on [Month Name] to use [Month Number].
Hi @bo_afk
I think you should create a column like MMDD like 01-Jan, 02-Mar would be 0101, 0302, That will sort on month and date.
What you need is a numeric column to use as the sort order.
MonthDaySort = MONTH ( uvw_RescoMobileAudit[Created On] ) * 100 + DAY ( uvw_RescoMobileAudit[Created On] )
Then you set the sort on the Month/Day to use MonthDaySort. In the image below I am setting the sort order on [Month Name] to use [Month Number].
Hi @bo_afk
In your table create a new column, use the following formula
Sort Order = VALUE ( TableName[Date] )
Then Select your ShortMonthName column go to Modeling Tab >> Sort By Col (drop down) select Sort Order Column. The visual should update automatically
---
PS: You can even sort it by your Date Column, just in case you haven't used it for sorting any other column already
User | Count |
---|---|
94 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |