Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kathyyy19
Helper III
Helper III

How to shorten the dates in power bi calendar table

Hi Everyone,

 

I have a calender table in power bi and one of the columns shows 'MonthYear' in below format.

 

kathyyy19_0-1695321092261.png

 

How can I shorten it to 'Jan-2023', 'Feb-2023' or 'Jan-23' 'Feb-23' for example?

 

Thank you!

2 ACCEPTED SOLUTIONS
rsbin
Super User
Super User

@kathyyy19 ,

Please try this as another Calculated Column:

AbbMonthYear = FORMAT( [MonthYear], "mmm-yyyy" )

Regards,

 

View solution in original post

@kathyyy19 ,

Use Sort by Column to sort this new Column by your original MonthYear column

rsbin_0-1695323407949.png

 

View solution in original post

4 REPLIES 4
rsbin
Super User
Super User

@kathyyy19 ,

Please try this as another Calculated Column:

AbbMonthYear = FORMAT( [MonthYear], "mmm-yyyy" )

Regards,

 

Hi rsbin,

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?

 

Thanks!

@kathyyy19 ,

Use Sort by Column to sort this new Column by your original MonthYear column

rsbin_0-1695323407949.png

 

Thank you rsbin for your fast reply!! You are amazing!!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.