Date Not Populating

Question

Hi.&nbsp; I have a fact table with a date field that I have connected to my Date table, but when I try to add the month/year field from my Date table to my table visual, it's not populating.&nbsp; This is the first time this has happened.&nbsp; I have many, many similar connections that work fine.&nbsp; I've ensured that the date in my fact table is identified as a date, and there is a relationship between the formal Date table and the date in the fact table.&nbsp; Any suggestions?

theoc · Answer

Hi&nbsp;Anonymous&nbsp;&nbsp;Can you check the relationship in your Data Model to ensure it's established appropriately for using it for slicers, etc?&nbsp;&nbsp;&nbsp;Also, are you able to provide a snippet of the visual's fields you've put together along with your data model view (if the above doesn't resolve)?&nbsp;Thanks in advance!Theo&nbsp;

vahiddm · Answer

Hi&nbsp;Anonymous&nbsp;&nbsp;Can you share your PBIX file or sample file?&nbsp;you can upload and share on&nbsp;https://wetransfer.com/&nbsp;Appreciate your Kudos!!LinkedIn:&nbsp;www.linkedin.com/in/vahid-dm/&nbsp;&nbsp;

anonymous · Answer

I checked the relationship and even deleted and redid it.&nbsp; Now it appears that there is something very wrong with all my pbix files, as everytime I go to open, they freeze.&nbsp; I need to research what is happening and get back to you.

anonymous · Answer

Here is the relationship.&nbsp; All I want to do is to be able to populate a simple table visual with the monthyear from the calendar table.&nbsp; I added a monthyear column in PQ, but would like to do it the way I always have by just pulling it in from the Date table.&nbsp;&nbsp;

theoc · Answer

Anonymous&nbsp;can you also please provide a snippet of your relationships / data model.

Forum Discussion

Date Not Populating

6 Replies

Related content

Population dynamic graaph

Date not populating

Selectedvalue Date Slicer not populating

Averages to populate in missing dates

Date Slicer should populate the date range using start date and end date columns using other slicers