Check Out The Relative Date Slicer in Power BI!

In this video, Justin Vogel from Pragmatic Works introduces one of the most underrated filters in Power BI: the Relative Date Slicer. This tool allows users to create dynamic time filters that automatically adjust based on the current date. Whether you’re working with data from the past or future, the Relative Date Slicer gives you the flexibility to explore different time periods with ease.

What is the Relative Date Slicer?

The Relative Date Slicer is a dynamic time filter that allows you to select a moving window of time such as the last 30 days, the previous 3 months, or even a future date range. This feature automatically recalculates time periods based on the current date, making it an excellent tool for time-sensitive reports.

Setting Up the Relative Date Slicer

• Start by creating a date table using the CALENDAR AUTO function in DAX.
• Ensure the date table is marked as a Date Table to enable time intelligence features.
• Once the table is set up, insert the Date column into the slicer and set it to "Relative Date" mode in the slicer settings.

Relative Date Slicer Settings

• Choose from predefined options like "Last X days," "This month," "Next month," or custom ranges.
• Adjust the time window by selecting options like "Last 5 years," which will dynamically adjust the data displayed.
• For more precision, you can anchor the slicer to a specific date, such as the beginning of a quarter or another key date.

Understanding the Difference: Calendar vs. Non-Calendar

When using the Relative Date Slicer, it's important to understand the distinction between "calendar" and "non-calendar" options. For example, selecting the "Last 5 years (calendar)" will exclude the current year, while "Last 5 years" will include it. This option also applies to months and weeks, so understanding the impact of each setting is key to getting the right data.

Bonus Trick: Using Bookmarks and Bookmark Navigator

As a bonus, Justin shows how to use bookmarks in Power BI to quickly switch between different time periods. You can create bookmarks for various date ranges (e.g., last 5 years, last 10 years) and use the Bookmark Navigator to make it easy for users to navigate between them with just a click. This is especially useful for reports that require frequent time comparisons.

Conclusion

The Relative Date Slicer is a powerful yet often overlooked feature in Power BI that can greatly improve the usability of your reports. By understanding how to set it up and utilize its different settings, you can offer your users more dynamic and responsive reporting options. Be sure to experiment with this feature and explore how it can enhance your Power BI dashboards.

Interested in learning more? Be sure to check out Pragmatic Works’ suite of Power BI training courses, where you'll find everything from beginner to advanced content on slicers, DAX, and much more!

For more Power BI tips and tutorials, like and subscribe to Pragmatic Works’ YouTube channel!

Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Power BI and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.