Forum Discussion

Atlan's avatar
Atlan
Frequent Visitor
2 years ago
Solved

Problem with two Date columns

Hi, I use a query that produce a column with different time values (03.01.2022 09:48:44). In Power Bi I use the Preselected Slicer with a Date Table. In the Datetable all times 00:00:00. So I think ...
Need Help
  • sayaliredij's avatar
    sayaliredij
    2 years ago

    Hello Atlan 

     

    as i can not see all the settings and data completely, i have tried to prepare sample file using same fields like you (only necessary one) 

    DateFilters.pbix

    please download this and verify all the settings. 

    let me know if it helps. 

     

    Thanks,

    Sayali

sayaliredij's avatar
sayaliredij
Solution Sage
2 years ago

Looks all good 

Just connect creation date to the date from date table and check if its working

Thanks,

sayali 

 

  • Atlan's avatar
    Atlan
    Frequent Visitor
    2 years ago

    Hi sayaliredij 

    i connectet both tables like the enclosed pic. I enclosed also two pics. The Tableview is empty but there are two values that must show in Jan. 24. But nothing. Only the values that orginaly had the date value with time 00:00:00 will show in the tablevisual.

     

    Thanks for your efforts.

    Regards

    Atlan