Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, colleagues!
Hope you are well.
I'm struggling to create a slicer for time on Power BI.
I have a table with the Start Time and the End Time for each item.
I would like to create a slicer/filter where people could indicate the start time and the end time and power BI will filter the items on the table.
My table:
id | starttime | endtime
3 | 4:30 AM | 6:46 AM
1 | 12:01 AM | 3:37 AM
4 | 12:10 PM | 12:52 PM
5 | 12:10 PM | 12:41 PM
6 | 12:10 PM | 12:49 PM
7 | 12:10 PM | 1:00 PM
Example if I select 12:00 PM as start time and 01:00PM as end time it should show me the items 4,5,6 and 7.
I've tried using the slicer, however looks like the option "between" only works with Dates.
Can someone help me?
Solved! Go to Solution.
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RiFbifN58ZozX2sVB?e=5wVS3B
Hi @brceliolu
Start time and End time are split into 2 columns, so if you need to filter data based on the slot between the start date and end date you need 2 slicers one for each column:
The slicers should be drop-down lists.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @brceliolu
Start time and End time are split into 2 columns, so if you need to filter data based on the slot between the start date and end date you need 2 slicers one for each column:
The slicers should be drop-down lists.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RiFbifN58ZozX2sVB?e=5wVS3B
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |