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

Microsoft PBI Certified
Download SampleInstructions

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.

Visual capabilities

This visual is certified by Power BI

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