https://store-images.s-microsoft.com/image/apps.60174.02315729-9977-48d2-8f67-b40acefb7f2b.c4bc2640-40fe-44bf-8e5f-7607a61b5911.ce188840-fe57-4105-ab00-d7eb06ec67bd
Simple Dynamic Date Slicer
by Clear iQ Analytics
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:
a. Days
b. Weeks
c. Weeks (Calendar)
d. Months
e. Months (Calendar)
f. Years
g. Years (Calendar)
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
ONLY 1 FILTER is applied at a time—the slicers work independently of one another. 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 persisted so the slicer remains consistent when navigating away from and back to the page.
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:
a. Days
b. Weeks
c. Weeks (Calendar)
d. Months
e. Months (Calendar)
f. Years
g. Years (Calendar)
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
ONLY 1 FILTER is applied at a time—the slicers work independently of one another. 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 persisted so the slicer remains consistent when navigating away from and back to the page.
Visual capabilities
When this visual is used, it
- Can access external services or resources
At a glance
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