Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Slicer from Date table does not work

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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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.