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.
Hello,
I've got my date slicer :
Month+Year
For example :
January 2018
February 2018
March 2018
April 2018
April 2019
May 2018
May 2019
My column "MonthYear" is sorted by month number.
I do not understand how to sort this date. It's really important to have Month by Month et year by year, I don't want years to be mixed!
Thanks by advance for ur help, I researched but I didn't really find an answer to this specific question..
Have a nice evening!
Solved! Go to Solution.
Hi @Anonymous ,
Create a new column in your date table for year month as follows:
YearMonthNum = FORMAT( [Date], "YYYYMM")
Then sort your column YYYY-MMM by YearMonthNum.
Regards,
Fernando
Hi @Anonymous ,
Create a new column in your date table for year month as follows:
YearMonthNum = FORMAT( [Date], "YYYYMM")
Then sort your column YYYY-MMM by YearMonthNum.
Regards,
Fernando
Thanks so much ! Have a nice day
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |