Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |