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.

 

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
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.

4 Replies

  • 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

  • AnkitKukreja's avatar
    AnkitKukreja
    Super User
    4 years ago

    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.