Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date Filter Not Working

Hello everyone.

I'm having a trouble with this.
Date Filter is not working to filter the relationship table.

no calculation or measures applied ..
this is my first time to encounter this.




 

  • Anonymous . change the data type of created date as date time and and use a format that show time. Does it show time other than 12:00 AM. if yes you need to create a date without time and use it

     

    example 

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

2 Replies

  • Anonymous . change the data type of created date as date time and and use a format that show time. Does it show time other than 12:00 AM. if yes you need to create a date without time and use it

     

    example 

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous 

    I restored your scene and found that everything is running normally. This is a screenshot.

    Corresponding time column properties.

    So could you provide your pbix file ? Maybe this will help us solve the problem .

     

    Best Regards

    Community Support Team _ Ailsa Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.