Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

Filter across pages

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

Tips and Tricks

olgad
3 years ago
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.

4 Replies

olgad
Resident Rockstar
3 years ago
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.
- Anonymous
  Not applicable
  3 years ago
  It works 🙂
  That is so a helpful idea. Thanks so much
olgad
Resident Rockstar
3 years ago
Is the year field in slicer coming from a separate date table? Which field serves as a slicer?
- Anonymous
  Not applicable
  3 years ago
  yes, separate date tables. I used the year of the invoice table as slicer.