Forum Discussion
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
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:
-
Go to Home > Transform Data to open Power Query Editor.
-
Select the column with the datetime values.
-
Go to the Transform tab.
-
Click on Date > Date Only.
-
Close and Apply changes to Power BI.
This will transform the column to a date-only format in the Power Query Editor.