caballaire
New Member
I set up a calendar table in Power Query using "only create a connection" and I added it to the data model.
I set up the relationships with the fact table and they are marked active.
HOWEVER--the slicer is not working. It only recognizes 36 rows of data and the rest come back (blank)


I noticed the fields show as a long date including time of day. I set each field to show short date but still it is not sorting on all the rows of data. also, note how in the relationship screen the date is the long format.
What am I missing????
I set up the relationships with the fact table and they are marked active.
HOWEVER--the slicer is not working. It only recognizes 36 rows of data and the rest come back (blank)


I noticed the fields show as a long date including time of day. I set each field to show short date but still it is not sorting on all the rows of data. also, note how in the relationship screen the date is the long format.
What am I missing????