Override date filter in Power BI

Override date filter in Power BI

Override date filter in Power BI. Overriding standard date filtering in Power BI can be trickier than you can imagine.

Recently, a friend of mine came across with an interesting request he got from his client. They needed to see values for the specified period in the past, based on dates selection.

For example, if they select March 31st, 2020, they need to see values for the previous 12 months, so starting from April 1st, 2019. Additionally, they need an option to choose a specific date and see values from the beginning of the year for the selected date. Again, if they select March 31st, 2020, they need to see values starting from January 1st, 2020. Visuals would be adjusted to dynamically change based on user selection.

That being said, Edit Interactions, as a way to remove the filter from specific visual, was not an option, since it would completely deny a user from selecting any specific value for filtering.

Tricky part

The trickiest thing here is establishing a proper relationship between the Date dimension and the fact table. Because, if you rely on the “normal” relationship between the Date dimension and fact table, data will be filtered based on dates selection which serves as a relationship between these two tables.

Let’s head over to Power BI Desktop and see if something can be done.

power-bi data-science data-visualization data-modeling towards-data-science

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Tableau vs Power BI: Comparing the Data Visualization Tools

In analytics, Tableau is the leading visualisation tool. Its rich analytical features and attention to data details are the reason behind its popularity. Power BI, on the other hand, is preferred by professionals who are more comfortable with...

How to reduce your Power BI model size by 90%!

The final part of “Brain & Muscles” behind Power BI series, shows a real-life showcase of data model optimization and emphasizes general rules for reducing data model

Power Query tips for every Power BI Developer

Use these simple yet powerful techniques to speed-up your Power BI development. If someone asks you to define the Power Query, what should you say?

Explore your JIRA Data with Power BI

JIRA Software provides bug tracking, issue tracking, and project management capabilities for teams and organizations. The JIRA content pack for Power BI helps you quickly import JIRA data so you can get an instant dashboard to analyze workloads...

Managing your Data with Microsoft’s Power BI

In a world where the sheer amount of data is often overwhelming, the ability to interrogate and organise data to make meaningful business decisions is more important than ever. Microsoft have created Power BI to enable every day users to use the...