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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
ghdunn
Helper III
Helper III

mmm-yy Date Format in Reports?

I have trawled through a lot of posts on date formatting in reports but am I correct in saying I am limited to the list below?

 

I want to format a Matrix column by mmm-yy but cannot see that option:

 

Capture.PNG

1 ACCEPTED SOLUTION
Mariusz
Community Champion
Community Champion

Hi @ghdunn 

 

It looks like it's not available, but you can add a columnlike below.

 column = FORMAT( [Date], "MMM-yy" )
Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

View solution in original post

3 REPLIES 3
Mariusz
Community Champion
Community Champion

Hi @ghdunn 

 

It looks like it's not available, but you can add a columnlike below.

 column = FORMAT( [Date], "MMM-yy" )
Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

@Mariusz 

 

My bad...DAX column!

So sorry @Mariusz ...where do i put that code??

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.