Forum Discussion
Add time to date range slicer
This is my sample data
| Date | Count |
02/05/2022 10:05:36 AM | 10 |
| 02/05/2022 11:05:36 AM | 15 |
| 02/05/2022 12:05:36 PM | 20 |
| 02/05/2022 01:05:36 PM | 20 |
| 02/06/2022 10:05:36 AM | 15 |
| 02/06/2022 11:05:36 AM | 10 |
| 02/06/2022 12:05:36 PM | 15 |
| 02/06/2022 01:05:36 PM | 10 |
| 02/07/2022 10:05:36 AM | 10 |
| 02/07/2022 11:05:36 AM | 10 |
| 02/07/2022 12:05:36 PM | 20 |
| 02/07/2022 01:05:36 PM | 15 |
Filter: 02/05/2022 11:05:36 AM to 02/07/2022 12:05:36 PM.
There is only date range filter in a slicer. But there is no time integration. I can do it from advance filter. But that is not my requirement. I need it using custom slicer. I require the count information from 11:05:36 am of 5th february to 12:05:36pm of 7th february. I am stuck in this problem. Please help.
1 Reply
Hi Anonymous ,
It seems when you place a Date/time column in the Slicer you can only use the List or Dropdown options to select a datetime value.
Or checkout this blog: Advanced Time Line Slicer - Sorting data by shifts... - Microsoft Power BI Community
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
