How to filter 3 Matrix tables with one date sync slicer - 2 tables reflecting past 2 months?

[iamriz]

Hello, I am having a hard time figuring out how to have a single date sync slicer that would filter 3 Matrix tables - 2 of which reflecting past 2 months?

How to retain the 3rd date sync slicer that would achieve the table 1 and 2 count values?

I hope someone could help. Thanks in advance.

[v-robertq-msft · Accepted solution]

Hi, @iamriz 

According to your description and sample file, I guess you want to make a Slicer filter three tables(current, 1 month ago, 2 month ago), you can try my steps:

1. Create a Calendar table for Slicer:

Date = CALENDARAUTO()

2. Create these measures for Table1, Table2, Table3:

Count_Table1 =

var _selecteddate=MIN('Date'[Date])

return

CALCULATE(COUNT(Orders[OrderID]),

FILTER('Orders',

[Datetime]>=DATE(YEAR(_selecteddate),MONTH(_selecteddate)-1,DAY(_selecteddate))&&

[Datetime]<_selecteddate))

Count_Table2 =

var _selecteddate=MIN('Date'[Date])

return

CALCULATE(COUNT(Orders[OrderID]),

FILTER('Orders',

[Datetime]>=DATE(YEAR(_selecteddate),MONTH(_selecteddate)-2,DAY(_selecteddate))&&

[Datetime]<DATE(YEAR(_selecteddate),MONTH(_selecteddate)-1,DAY(_selecteddate))))

Count_Table3 =

CALCULATE(COUNT(Orders[OrderID]),FILTER('Orders','Orders'[Datetime]>=MIN('Date'[Date])&&'Orders'[Datetime]<=MAX('Date'[Date])))

3. Replace the field of Slicer with ‘Date’[Date], replace [Count] in Tables with new measures, then open visual interactions, like this:

And you can get what you want.

You can download my test pbix file here

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[iamriz]

Hi @v-robertq-msft , just what I was looking for. This is very helpful, thank you very much!!!