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
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
107 | |
105 | |
90 | |
61 |
User | Count |
---|---|
169 | |
138 | |
135 | |
102 | |
86 |