Slicer from Date table does not work

[Anonymous]

Hello,

I am quite new with Power BI and probably there is an easy fix to my problem.

I have 3 tables in my file.
1. Activity for an area in a warehouse (picking, movements, quantity, person id, etc...)
2.Shift KPI Data - person ID, their name, shift, etc...

3. Date table which I have created in Power BI with the Calendar() function.

Table 1 (Activity) is connected to Table 2 (Shift KPI Data) by the person ID. 
Table 1 (Activity) is connected to Table 3 (Date) by the date.

I have created few measures, which are giving me total number of picking per day for each shift.
What I am trying to do is create a slicer with the Date column from Date table, so that the user can select a date range or one day
for which he/she can see number of picking per shift, or total picks.

My problem: When I select a specific date in the slicer, nothing happens with my visuals. My visuals are using the measures I have created in case this is relevant.

I have check if I have linked the tables, they are, I have checked that in the modeling Tab.
If I take the date from table 1 (Activity) and use it in the slicer, then the visuals are changing, but if I am using the date from the Date table the visuals are not changing.

[Anonymous · Accepted solution]

Hello,

I think I found the solution, in case someone will read this post and can use the help.
I went back to the power query editor and changed the data type of my date column in table Activity to Date. It was originaly date and time.
After that I applied the changes and the connection between the two tables and my slicer are working!

[amitchandak]

@Anonymous , I doubt you date in the table Activity has time stamp. You can view that by making data type as datetime and choose a format with time

create a date column like this in DAX

Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime]))

or

In power query

DateTime.Date([datetime])

and join that with date table and try

Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw

[Anonymous]

Hello @amitchandak ,

Thank you for answering.

I have made sure that the format of the columns is the same in both tables - date/time like you have suggested, but unfortunately still doesn't work.

Also, I don't understand where is the measure you have used in your example:
[datetime] coming from? When I type in [ braket in Power BI, I see only my measures.
I don't see an option to upload a screen shot of the formats I have on both columns, sorry.