Filter by selected month and selected's previous month in different report pages

[Lyara]

Hi everyone,

I need help to filter by selected month in Page A and selected's previous month in Page B. 

My model is something like this:

So, If I Filter by March 2022 (it doesn't matter if Slicer or Panel filter) i need:

- PAGE A :  Data with date = 01/03/2022

- PAGE B :  Data widh date = 01/02/2022

It's possible? I'm new to Power BI and I don't know if I want something impossible or very easy.  😅

Thanks!

[amitchandak · Accepted solution]

@Lyara , First all use Sync slicer .

On one page use the current measure and in second-page use the prior measure

example measures

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))
next month Sales = CALCULATE(SUM(Sales[Sales Amount]),nextmonth('Date'[Date]))
this month = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH('Date'[Date])))
last MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH))))
previous month value = CALCULATE(sum('Table'[total hours value]),previousmonth('Date'[Date]))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[Lyara]

Whoa, It worked perfectly, you can even hide slicers on the sync panel 😍 I didn't know this functionality.

Thank you so much!