How to override Date Filters in Power BI


Problem

A few weeks back, I got a request from a client of mine who had a very special requirement. They wanted to display values for a specific period in the past based on the selected dates in the Power BI report. Let us assume that if we select 30 June 2020, the report has to display data from 01 July 2019 until 30 June 2020, which is data for the last 12 months. Let me demonstrate the issue here.

Consider the following Power BI report. Now, if I select any date value from the slicer, the bar chart shows data