Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
diskovered
Helper III
Helper III

Previous quarter report level filter for 3 different data sources

I have three data sources and linked all three using date (year, quarter, month).

 

I'm curious how do I go about using previous quarter in my page filter that would apply to all 3 data sources. Thanks

1 ACCEPTED SOLUTION

Hi @diskovered

One workaround is to create measure to show values of previous quarter.

for example, create measures

current_quarter = COUNT(Table1[Date])

previous_quarter = CALCULATE(COUNT('Table1'[Date]),PREVIOUSQUARTER('date table'[Date]))

10.png

11.png

 

Best Regards

Maggie

View solution in original post

4 REPLIES 4
v-juanli-msft
Community Support
Community Support

Hi @diskovered

If you import three data sources and the date table into one pbix, then create relationships amont these tables.

table1 <->  date table  based on date column

table2 <->  date table  based on date column

table3 <->  date table  based on date column

 

Next, when you add data from three tables on the same Report Page,

To get "previous quarter in my page filter that would apply to all 3 data sources"

 

add the "date" column from the "date table" in a slicer and select "relative slcier", 

Or in Page Level filter select "relative date range filter".

 

Reference:Use a relative date slicer and filter in Power BI Desktop

 

Best Regards

Maggie

Thanks for your help. Relative filter doesn't have previous quarter. Can this be done using a measure? Something like this? 

 

PREVIOUSQUARTER = PREVIOUSQUARTER(dim_Date[calendar_date])

 

PREVIOUS QUARTER.PNG

Hi @diskovered

One workaround is to create measure to show values of previous quarter.

for example, create measures

current_quarter = COUNT(Table1[Date])

previous_quarter = CALCULATE(COUNT('Table1'[Date]),PREVIOUSQUARTER('date table'[Date]))

10.png

11.png

 

Best Regards

Maggie

Perfect, I think I'll settle with this workaround. Thank you

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.