March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet 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
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
Solved! Go to 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]))
Best Regards
Maggie
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?
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]))
Best Regards
Maggie
Perfect, I think I'll settle with this workaround. Thank you
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
122 | |
98 | |
89 | |
73 | |
64 |
User | Count |
---|---|
138 | |
115 | |
115 | |
98 | |
98 |