Reports with multiple data source using multiple date range filters on each page

[Anonymous]

Hi guys

I got a report request, where I am dealing with 5 data sources from database views.

Each page in PowerBI report is using one data sources in each page.

Data Source 1 --> Year to Date

Data Source 2 --> Past three months

Data Source 3-->Current month
Data Source 4-->Current Month

Data Source 5 --> Past three months

I have a one Date dimension table and How to configure join conditions between Date Dimensio and All these 5 data sources?

Also need to consider the fact that Jan 2020 reporting need to consider 2019 Dec or older data only.

I have to let the user choose one date like Year(2019/2020) and apply the corresponding filters on all these sources.

How to design these types of reports?

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may apply virtual relationship in DAX measure.

• https://community.powerbi.com/t5/Desktop/Use-a-date-slicer-to-filter-on-a-period-instead-of-a-single...
• https://community.powerbi.com/t5/Desktop/Dynamic-Last-four-quarters/m-p/580125#M274416

[Greg_Deckler]

Sample data would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490