Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have a strange problem where I have a column imported to the dataset as text format while the data in the column is a date.
Example:
2021-08-01 (1. Aug 2021)
When I look at the table in the dataset (after importing it to the dataset), it looks correct:
2021-08-01
But, when I add it to a visual, any visual, it shows in this date format:
8/1/2021
As of my locale on my computer this would be
8. Jan 2021
Can someone explain why this is happening? The date is still formatted as a text if I mark it in the dataset.
What I would expect to happen is whenever I add this to a visual it should be treated as a text, not date.
Solved! Go to Solution.
Hi @coejnot ,
Have you tried changing it to a date using locale in Power Query?
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Hi @coejnot
When I import the same data, I get the correct result,
and my setting is,
If you don't want a date in text format to be automatically converted to Date type, you can change this setting,
Go to File - Options and settings - Options,
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @coejnot
When I import the same data, I get the correct result,
and my setting is,
If you don't want a date in text format to be automatically converted to Date type, you can change this setting,
Go to File - Options and settings - Options,
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
We did an conversion of the field to a date field in Power Query, I believe the use locale would also help.
Hi @coejnot ,
Have you tried changing it to a date using locale in Power Query?
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
We did an conversion of the field to a date field in Power Query, I believe the use locale would also help.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |