I have a calender table in power bi and one of the columns shows 'MonthYear' in below format.
How can I shorten it to 'Jan-2023', 'Feb-2023' or 'Jan-23' 'Feb-23' for example?
Solved! Go to Solution.
Thanks for your message. I tried your method but the new column has data type as 'text'. When I use this in my chart, I wanna sort my x-asix by the order of month. When they are in text format, they are sorted alphabeticallt which is not what i want. Any suggestion what I can do?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.