How to filter by hour, despite having full time info?

[Tradingpost]

I'm sorry for asking such a basic question. 

I'm ABSOLUTELY new to this program, I was just sucked doing into it yesterday. I kind of understand it's like an easier version of Excel but now I want to know one thing. 

In my datasets, I'm trying to filter data by the day. The issue is that, the data is recorded by time, right down to the absolute second. So when I filter it, it's filtering it by seconds. When it does that, it's basically telling me, there's 1 item for every second.

I want to ignore the Seconds and Hours part and just focus on the date. Is that possible? Tomorrow I will start watching the full courses & webinars but can someone please help me on this one for today T_T 

[Ashish_Mathur]

Hi,

Write this calculated column formula to extract date from the date/time stamp

=INT(Data[Date_time])

Change the Table and column name to your actual ones.

[Tradingpost]

I'm sorry. I tried doing that, but I don't think I fully understand what to do. I just want to filter it just by the date. 

Below is a screenshot.

As you can see, it's filtering it by date which is great, but it's also filtering it by time and seconds. How can I make powerBI just "ignore" the time? 

[Ashish_Mathur]

Hi,

In the thin blank panel on the left hand side, click on the secons icon (Data).  Select the appropriate Table and under modelling click on New Column.  Now write the formula that i shared with you.  In the visual, drag this new column.

[Tradingpost]

I'm really sorry. I don't think it seems to be working. 😞 

[Ashish_Mathur]

Share the link from where i can download your PBI file.

[Tradingpost]

I pressed share on PowerBI Cloud and this is the report link. I'm assuming this the link you need?

https://app.powerbi.com/groups/me/reports/b70e20b1-dc79-46ae-8906-5b932221f47c?ctid=6eae18b9-e630-47...

[Ashish_Mathur]

No, that is not the link.  I need the link from where i can download the PBI file.

[Tradingpost]

Can I email you the file directly? 

I greatly appreciate the help btw. If not, I'll try to upload it somewhere?

Edit : I managed to do the formula you gave me, except the date_time one. Now it looks like this.

[v-cherch-msft · Accepted solution]

Hi @Tradingpost

You may try to add column in Query Editor as below:

By the way, as Ashish_Mathur said. You also need to set the column data type to get the date column. 

Regards,

Cherie

[Ashish_Mathur]

Remove the [Date_time]