Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |