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
NC_03
Regular Visitor

Need help on how to change date format in Power BI Play Axis

How do I change the date format of the Play Axis?

NC_03_0-1696168420132.png

 

2 ACCEPTED SOLUTIONS

Hi @NC_03 ,

You can create another new calculated column as below to format with the expected date format as below and apply this new column on the Play Axis as below screenshot. Please find the details in the attachment.

vyiruanmsft_1-1696305391678.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Thank you so much!  I have done it.

View solution in original post

5 REPLIES 5
NC_03
Regular Visitor

Hi,

Please see screenshot, where the Play Axis still shows a different format compared to the Date Tab (Short Date).

NC_03_0-1696302930631.png

 

Hi @NC_03 ,

You can create another new calculated column as below to format with the expected date format as below and apply this new column on the Play Axis as below screenshot. Please find the details in the attachment.

vyiruanmsft_1-1696305391678.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you so much!  I have done it.

NC_03
Regular Visitor

If I go to column tools, the date format is a Short Date.

NC_03_1-1696168805907.png

 

 

Hi @NC_03 ,

You can click the down-pointing arrow in the dropdown list, and choose the proper data type from the list just as below screenshot.

vyiruanmsft_0-1696300250030.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.