The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I require the visualization filtered by date and time. For example: filter the date from xx/xx/xxxx hh:mm to xx/xx/xxxx hh:mm. I want this to get integrated in slicer. There is the option in advance filtering but i require it in slicer. Please help ...
Is it possible to have this requirement 8 september 2022 8:00 am to 10 sept 2022 8:00pm from two dimension table. If you have code sample.. it will be a great help.
Although it would be convenient to have the date and time on the same slicer, doing so would add a lot of extra bulk to your data model. The number of days on your calendar would be multiplied by the 1440 minutes in one day. Over 500,000 rows would be created by one calendar.
Therefore, separating the date and time into two dimension tables and using one slicer for date and another for time is the best option.
User | Count |
---|---|
70 | |
64 | |
61 | |
49 | |
28 |
User | Count |
---|---|
117 | |
81 | |
65 | |
55 | |
43 |