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! 🙂
I didn't get any error it just doesn't work when I use the filters. so so basically i created the relationship and then used the calendar table as a date filter, this is when it doesn't work.
Highlighted in blue are the filters taken from the calendar table and everything else comes from my other table.
Relationship is between "Date" and "DateCompleted"
thanks,
Hmm I really need some more information. Would it be possible to share your PBIX? If you don't want to share it widely you can PM me the link and I will try and solve this for you.
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! 🙂
I can't share the file because I don't have authorization to so so (company) and you can't open it even if I share it because of database security.
Thank you for trying though!