https://store-images.s-microsoft.com/image/apps.60174.02315729-9977-48d2-8f67-b40acefb7f2b.c4bc2640-40fe-44bf-8e5f-7607a61b5911.ce188840-fe57-4105-ab00-d7eb06ec67bd

Dynamic Date Slicer

بواسطة Clear iQ Analytics

Free trial badge
Microsoft PBI Certified
تنزيل نموذجالإرشادات

Switch Between a Fixed and Relative Date Selection Seamlessly

The Simple Dynamic Date Slicer lets users filter time-based data in Power BI using either a Fixed or Relative mode. Designed to be integrated into Power BI to add more flexibility for users when it comes to filtering a dataset using a date range.

Features:

Fixed mode
1. Select Start Date (or type in date)
2. Select End Date (or type in date)

Relative mode
1. Select (Last / Next / This)
2. Enter numeric value
3. Choose period:
   3a. Days
   3b. Weeks
   3c. Weeks (Calendar)
   3d. Months
   3e. Months (Calendar)
   3f. Years
   3g. Years (Calendar)

Dynamic Button
1. Select Either Relative or Fixed
2. ONLY 1 FILTER is applied at a time—the slicers work independently of one another.

Configurable UI
1. Configure colors, text styles, outlines, and more!
2. Toggleable Clear button
3. Toggle On/Off labels for specific relative units (example: disabling Weeks (Calendar) if it isn’t needed).

Additional info
For Fixed ranges, labels clamp to the dataset’s effective min/max when a user selects a range outside the available data so it’s clear what’s included. The selected mode and values are persistent; the slicer remains consistent when navigating away from and back to the page.

القدرات المرئية

لمحة سريعة

https://store-images.s-microsoft.com/image/apps.34030.02315729-9977-48d2-8f67-b40acefb7f2b.4bc60ef1-e359-4359-aa59-819c2fff9c54.e7e053cf-1a21-4d0c-9a2f-072c6d64b1ed
https://store-images.s-microsoft.com/image/apps.12997.02315729-9977-48d2-8f67-b40acefb7f2b.4bc60ef1-e359-4359-aa59-819c2fff9c54.657ce528-6946-4511-b58f-8b7bc4dc78a0
https://store-images.s-microsoft.com/image/apps.35121.02315729-9977-48d2-8f67-b40acefb7f2b.4bc60ef1-e359-4359-aa59-819c2fff9c54.ec5bc602-d46c-4001-8b6e-bf04e8af08d2