How to Add Time Filter Along with Date Slicer for a DateTime Column in Power BI?

[manoj_0911]

How to Add Time Filter Along with Date Slicer for a DateTime Column in Power BI?

Hi All,

I have a DateTime column in my data source (example: CreatedDateTime).

Currently, I am using this column to show a Date slicer in my Power BI report.

Now the customer requirement is:

👉 Along with Date filter, they also want to filter by Time (either exact time or time range).

Example scenarios:

• Filter data between 10:00 AM – 12:00 PM

• Or filter by specific hour (like 14:00 – 15:00)

What is the best practice to achieve this?

Any suggestions or best practices would be helpful.

Thanks in advance!

[danextian · Accepted solution]

Hi @manoj_0911 

Power BI range slicer doesnt suppor time. If you have a time column add add to a range slicer, the values will be displayed as date. From your datetime, create new column by parsing both the date and start of hour as number.

Use date and start of hour columns in a  range slicer

Please see the attached pbix.

[v-kpoloju-msft]

Hi @manoj_0911, 

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to @cengizhanarslan, @danextian, @Irwan,  for those inputs on this thread.

Has your issue been resolved? If the response provided by the community member @cengizhanarslan, @danextian, @Irwan,  addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

Thank you for using the Microsoft Community Forum.

[v-kpoloju-msft]

Hi @manoj_0911,

Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.

[cengizhanarslan · Accepted solution]

Best practice is don’t use the raw DateTime column directly for this. Instead, split it into Date + Time components (or build a Time dimension) and use separate slicers.

[danextian · Accepted solution]

Hi @manoj_0911 

Power BI range slicer doesnt suppor time. If you have a time column add add to a range slicer, the values will be displayed as date. From your datetime, create new column by parsing both the date and start of hour as number.

Use date and start of hour columns in a  range slicer

Please see the attached pbix.

[Irwan]

hello @manoj_0911 

in between date slicer visual, it will only show a date even it is a datetime format unless you are using tile or dropdown or vertical list which you need to select one by one.

as for filtering using time, in my opinion the best is using filter pane since there is a time selection.

Hope this will help.

Thank you.