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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.