Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hello friends,
my report has dates from 2 years (2021 and 2022).
Since we have 2022 a problem occured.
In my calendar I use a monthname which I create: (sorry, I am german)
Monatsname = FORMAT('RekAussNacharbCalendar'[Datum],"MMM")
Then I sort the column by monthnumber
Monatszahl = MONTH('RekAussNacharbCalendar'[Datum])
I use a line chart where I need to view both years, 2021 and 2022.
However then in the linechart both januaries are summed up - not good.
Next I created a "uniqe monthname":
Monat eindeutig = FORMAT(RekAussNacharbCalendar[Datum],"YYYY MMM")
I thought this would solve my problem but then it turned out that sorting in the linechart is wrong.
First there is 2021 Jan, then 2022 Jan and then 2021 Feb.
Question: how can I sort my unique month the right way?
Thank you very much in advance.
Solved! Go to Solution.
@cosmicyes , Create a sort column for this one too
Monat eindeutig = FORMAT(RekAussNacharbCalendar[Datum],"YYYY MMM")
Monat eindeutig Sort = FORMAT(RekAussNacharbCalendar[Datum],"YYYYMM")
Mark the second column as sort column and use first column
Thank you @amitchandak
works perfect.
Life can be so easy if you know what you are doing 😉
@cosmicyes , Create a sort column for this one too
Monat eindeutig = FORMAT(RekAussNacharbCalendar[Datum],"YYYY MMM")
Monat eindeutig Sort = FORMAT(RekAussNacharbCalendar[Datum],"YYYYMM")
Mark the second column as sort column and use first column
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.