Filter across pages

[lost_flower]

Hi community,

I have two visual pages. One with the year of invoices and another with the year of sales orders.

I would like to filter, for example 2021 for invoices and this year should automatically be the filter for the sales orders too.

Is this somehow possible? I have tried "sync slicers", but this is not working.

thanks

[olgad · Accepted solution]

Please create a datatable, the simplest way is to use calendar function https://learn.microsoft.com/en-us/dax/calendar-function-dax

then create relationship to your invoice date and to your sales order date, then use that date column from new datatable.

[lost_flower]

It works 🙂

That is so a helpful idea. Thanks so much

[olgad]

Is the year field in slicer coming from a separate date table? Which field serves as a slicer?

[lost_flower]

yes, separate date tables. I used the year of the invoice table as slicer.