This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.