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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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