Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
94 | |
90 | |
83 | |
76 | |
49 |
User | Count |
---|---|
145 | |
140 | |
109 | |
68 | |
55 |