Calendar Table slicer not working

[chrisy8s]

Hello,

I have two tables with sales activity data (one email, one phone calls) with numerous date fields. Both tables have the same field "actualend" which is the date the activity was completed.

I created a calendar table and have linked the "actualend" fields from both tables to the "date" field in the calendar table.

I have created a measure that counts the rows in the phone calls table that have a specific state code. I have a similar field for the emails

Completed Calls = COUNTROWS(filter(phonecalls,phonecalls[statecode]=1))

This measure calculates properly and is being used to create an activity dashboard.  However when I try to slice the data using the "date" field it returns no values anytime the slicer is used.

Please help!  Ive tried all kinds of videos and tutorials and have wasted far too many hours on what I thought we be a simple solution!  

Thanks

[BA_Pete · Accepted solution]

Hi @chrisy8s ,

Difficult to say without seeing your PBIX file, but my first guess would be that the date columns you are making your relationships on are not set as Date data type.

Go into your calendar query and each of your fact queries in Power Query and make sure calendar[date], factEmails[actualend], and factCalls[actualend] are all properly set to DATE data type.

Pete

[AnkitKukreja]

Hi! @chrisy8s 

Can you check you've a active relationship? Also, check if the table is marked a date table and the date columns are of Date as Data type.
Please share your pbix and I might have a look into it.

[BA_Pete · Accepted solution]

Hi @chrisy8s ,

Difficult to say without seeing your PBIX file, but my first guess would be that the date columns you are making your relationships on are not set as Date data type.

Go into your calendar query and each of your fact queries in Power Query and make sure calendar[date], factEmails[actualend], and factCalls[actualend] are all properly set to DATE data type.

Pete

[chrisy8s · Accepted solution]

Turns out the date in the calendar table did not have the time.  I had to transform the data in the other tables to date only and it worked.

[BA_Pete]

@chrisy8s ,

Cool, glad to hear it's working for you.

Please mark the answer that helped you as the solution to help others find the answer quicker in future.

Pete