Reformat datetime to only date

Hi mj2024 - Go to Data View in Power BI.

Select the table containing your datetime column.

Click on the column with datetime values (e.g., YourColumnName).

In the Column Tools tab, locate the Format dropdown.

Choose the Date format (e.g., dd/mm/yyyy or yyyy-mm-dd).

This will display only the date part while keeping the underlying datetime data.

or option 2:

If you prefer to fix this at the query level:

1. Go to Home > Transform Data to open Power Query Editor.

2. Select the column with the datetime values.

3. Go to the Transform tab.

4. Click on Date > Date Only.

5. Close and Apply changes to Power BI.

   This will transform the column to a date-only format in the Power Query Editor.

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

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

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!

You can also try another option using the sql query 

SELECT CAST('Datetime column' AS Date) AS ConvertedDate from Tablename