Forum Discussion

vimina's avatar
vimina
Frequent Visitor
2 years ago
Solved

Time Filters in Power BI for Specific Time Range

Is there any possibility in Power BI that would allow us to filter by Time for each day.
for eg. filter the time between 10AM and 1 PM
Attached the pbix file for reference.

https://drive.google.com/file/d/1VAoJ19JKYQMKgW-_elJcDnzpQSK-IEGA/view?usp=sharing 
In This eg can i number of calls between 7:00 - 9:00 like the "between" style in slicer setting for dates 

Need Help
  • MNedix's avatar
    MNedix
    2 years ago

    Hi,

    To my knowledge there no direct time filter in PowerBi. However, you can easily do it by creating an additional column which extracts only the hour and then use that column as a filter. I did the following on your file:

     

    1. Created new Column in the Table_Call Details table

    Hour_Call = HOUR('Table_Call Details'[Time])

    This will return the hour as an integer

    2. Used the column as a filter (see below):

     

     

    If that's what you were looking for please mark it as a solution so others can see it.

2 Replies

  • MNedix's avatar
    MNedix
    Icon for Solution Sage rankSolution Sage
    2 years ago

    Hi,

    To my knowledge there no direct time filter in PowerBi. However, you can easily do it by creating an additional column which extracts only the hour and then use that column as a filter. I did the following on your file:

     

    1. Created new Column in the Table_Call Details table

    Hour_Call = HOUR('Table_Call Details'[Time])

    This will return the hour as an integer

    2. Used the column as a filter (see below):

     

     

    If that's what you were looking for please mark it as a solution so others can see it.