Forum Discussion
Calendar use
Hi Anonymous ,
I see your date column has a format of 'yyyy-mm-dd HH:MM:SS UTC' and per my testing, that doesn't play well in PowerBI. What you can do is import it as text, create a new column based on that dateComplete column and removing the ' UTC' part of it, then change the type of the new column to DateTime.
Then create the relationship with the datetable, then drag the Date column from the datetable into your visual and that should work.
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Hi,
I can confirm #1 and #3.
About #2 i'm not able to change type to date. whenever i try to do so it changes all the rows to 'Err'. if i use the filters everything will be blank as shown in the screenshots
Resident RockstarHi Anonymous ,
I just put in a reply on your other topic, but I think it might has the same problem. The problem is the following: you are loading data in which you think is in date format but actually isn't. Therefor, PowerBI cannot resolve the values to dates and throws errors. Think of it like this:
Date 01/13/2019 is a perfect valid US notation. But in the Netherlands, this would resolve in an error because this means the first of the 13th month of 2019.
What you can do is two fold: change the locale for import in your settings to something that is corresponding with the datasource. See the following screenshot.
Then, you can change the type to date(time) in powerquery and try again.