Forum Discussion
Solved
Calendar Table slicer not working
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....
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
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.
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.