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.
In my dataset I have a column for day of the month (1, 2, 3...etc) and I have a column for month name (January, February...etc).
I have combined these two columns into a new column DayMonth to get "1 January", "2 January" etc. However, when I use this in a line chart and sort by DayMonth ascending it doesn't work properly and it's not sorted by the increasing numbers.
Anyone know why this is the case and how to fix it?
Thanks
afk
Solved! Go to Solution.
I think should create a column like MMDD like 01-Jan, 02-Mar would be 0101, 0302, That will sort on month and date.
I think should create a column like MMDD like 01-Jan, 02-Mar would be 0101, 0302, That will sort on month and date.
Hi @amitchandak
That seemed to have done the trick, thanks!
Could you explain why my previous method didn't work?
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |