Forum Discussion

mj2024's avatar
mj2024
Helper II
1 year ago
Solved

Reformat datetime to only date

Hi everyone I have a table coming from sql server that is a datetime.  In PowerBI I only want date not time.  How do I fix this?  The data is being displayed in a PowerBI table: Thank you
Need Help
  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    1 year ago

    Hi mj2024 ,

    In your table view, select the desired column and change the data type to date:

     

v-achippa's avatar
v-achippa
Community Support
1 year ago

Hi mj2024,

Thank you for reaching out to Microsoft Fabric Community.

 

Below is the simple approach to change from date and time to only date in Power BI

  1. Open the Report page and from the Home ribbon select Transform data
  2. A new Power Query Editor window will open
  3. Now for the required column, beside column name there is data type, click on the data type and from there select the Date data type. It will display only the date but not the time.
     

Before:

After:

 

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

 

Thank and Regards,

Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    Hi mj2024,

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance?

    If my response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

     

    Thank you for being a part of the Microsoft Fabric Community Forum!

     

    Thanks and Regards,

    Anjan Kumar Chippa

    • v-achippa's avatar
      v-achippa
      Community Support
      1 year ago

      Hi mj2024,

       

      We wanted to kindly follow up to check if the solution I have provided for the issue worked? If the issue is resolved, please mark the solution as Accept as solution to help the other members of the community find it more quickly. or let us know if you need any further assistance?

      Don't forget to give a "Kudos" – I’d truly appreciate it! 

       

      Thank you for being a part of the Microsoft Fabric Community Forum!

       

      Thanks and Regards,

      Anjan Kumar Chippa