Multiple Slicers and Matrixs on One Page

[Anonymous]

Greetings! Let's get right into it!

I have a Dashboard in PowerBI, with two matrixes showing the same kind of data (Let's say "Sales" for reference sake) - and I'd like to make the matrixes (1 and 2) to show two different years each, so you can see "January Sales 2023" and "January Sales 2022" Side by side. 

Currently, what I've done is created a sort of Slicer Panel, with slicers I'd like to only effect matrix 1, and slicers I'd like to separately effect matrix 2.

IS this even plausible, or ought I try I different approach? I'm not sure what the steps to take would be to make the slicers only effect certain elements like that.

Any advice would be very helpful, I'm still rather new to PowerBi, so many thanks!

[amitchandak]

@Anonymous , One way is this year vs last year measure using time intelligence

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))


last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))

Or have a slicer on an independent date table

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -12)
return
calculate( sum(Table[Value]), filter('Date', eomonth( 'Date'[Date],0) in {eomonth(_max,0) , eomonth(_min,0) } ))

Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI