Forum Discussion

jmikel's avatar
jmikel
New Member
1 year ago
Solved

Date Format not working when refreshed

I have a report with the following:   1. Date source pulls field in the following format 23/5/2025 (DD/MM/YYYY)  2. I use the following DAX to change data type to a date and have it recognized as ...
Need Help
  • v-sathmakuri's avatar
    v-sathmakuri
    1 year ago

    Hi jmikel ,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Instead of using Dax query you can also format date using power bi desktop format option.

     

    • Select the column, navigate to Column Tools, change Format to MM/dd/yyyy. I have formatted the date column following this process even the refresh is not throwing any error.

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks & Regards,

    Rekha,

    CustomerSupportTeam.

Cookistador's avatar
Cookistador
Super User
1 year ago

Hello jmikel 

Before your conversation in local, in whic format are your date ?

In the "Changed Type" step in Power Query, in which format is converted ?

 

Before to convert it into date, can you be sure that your Valid to date is in text type ? (and check that it is not converted into data in a previous step)