Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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.
It works 🙂
That is so a helpful idea. Thanks so much
Is the year field in slicer coming from a separate date table? Which field serves as a slicer?
yes, separate date tables. I used the year of the invoice table as slicer.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |