Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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! 😬
Check out the July 2025 Power BI update to learn about new features.