Forum Discussion

chrisy8s's avatar
chrisy8s
New Member
4 years ago
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....
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    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's avatar
    chrisy8s
    4 years ago

    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's avatar
BA_Pete
Super User
4 years ago

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's avatar
    chrisy8s
    New Member
    4 years ago

    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's avatar
      BA_Pete
      Super User
      4 years ago

      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