The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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! 😬