Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone, I have a column chart and I want to organize my data from the oldest data to the newest. In this case, for an unknown reason the data is organized like this: 2020, Dec / 2020, Nov /2021, Feb / 2021 , Jan
Is shown like this:
FYI: Ive created this column
Solved! Go to Solution.
You need to change your YearMonth definition to
YearMonth = FORMAT([Created],"YYYYMM")
or introduce a "Sort By" column that sorts by month number, not by month name.
You need to change your YearMonth definition to
YearMonth = FORMAT([Created],"YYYYMM")
or introduce a "Sort By" column that sorts by month number, not by month name.
Thank you so much and sorry for this silly question! 😬