Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 |
---|---|
117 | |
73 | |
58 | |
49 | |
48 |
User | Count |
---|---|
171 | |
122 | |
60 | |
59 | |
56 |