Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Hi Guys,
I am having an issue with date format as some of the columns are yyyy/mm/dd 00:00:00 and others are like yyyy-mm-dd 00.00.00
I could change the first format to show only dates yyyy/mm/dd, but when I try to change the format for the other columns to date only it gives me an error. is there any way to fix that?
Thank you
Solved! Go to Solution.
Hi @Hamidrezaei ,
If you only want the date, you could split this column based on space.
Here is my test result.
Now you could remove another time column or transform it, it is up to you.
Hi @Hamidrezaei ,
If you only want the date, you could split this column based on space.
Here is my test result.
Now you could remove another time column or transform it, it is up to you.
Hi @Hamidrezaei
replace the . with with : and it should work with both yyyy-mm-dd 00:00:00 and yyyy/mm/dd 00:00:00
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 3 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 11 | |
| 11 | |
| 5 | |
| 4 | |
| 3 |