Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
I have a date table which contains the Month name and Month Number. I setup Month Number in such a way that April considered as Month 1 and March treated as Month 12. I have sorted the column based on the Month number (as shown in the figure).
I am plotting a line graph on which the x-axis contains the Month name. I sorted the date column based on Month Number which means that the x-axis of the line graph shows the first month as April but still it shows January as its first name (as shown in the picture).
Could anyone help me in sorting out the issue?
Solved! Go to Solution.
hi @Dunner2020 - You need to follow the below steps to sort the month column by Month number. If you follow the below steps the data should be displayed in the month order that you require.
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Proud to be a Super User!
@Dunner2020 , Sort column for
Month for FY April to March //File is attached after Signature
Month = format([Date], "MMM")
Start Of Year= STARTOFYEAR('Date'[Date],"3/31")
Month Sort = DATEDIFF('Date'[Start Of Year], 'Date'[Date],MONTH)+1 // mark this as sort column
for CY
Month = format([Date], "MMM")
Month Sort = format([Date], "MM") // mark this as sort column
For Month Year
Month = format([Date], "MMM-YYYY")
Month Sort = format([Date], "YYYYMM") // mark this as sort column
Refer Steps :https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
In case you have FY other than
hi @Dunner2020 - You need to follow the below steps to sort the month column by Month number. If you follow the below steps the data should be displayed in the month order that you require.
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |