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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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