Forum Discussion

Sachintha's avatar
Sachintha
Icon for Helper III rankHelper III
4 years ago

Filter a table with DateTime by a Date slicer

I have a table with a DateTime column and a few other columns, say, { ID, Unit, and DateTime }. I'm including the raw data at the bottom of the post here.   After importing this CSV to Power BI, I'...
Need Help
Show and Tell
Tips and Tricks
davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
4 years ago

Hi Sachintha , You can convert the datetime to date in power query and this will solve your problem.

 

Hope this helps

 

Did I help you today? Please accept my solution and hit the Kudos button.

Sachintha's avatar
Sachintha
Icon for Helper III rankHelper III
4 years ago

I still need the DateTime to be DateTime, since I need to use the time in other charts in my report.

  • davehus's avatar
    davehus
    Icon for Memorable Member rankMemorable Member
    4 years ago

    Hi Sachintha , You could use DateTime.Date(datetimecolumn) in powerquery and extract the date and join to your data table. That way, you retain your datetime for other charts.

     

    Did I help you today? Please accept my solution and hit the Kudos button.