I have two tables and I want to create one slider for time filter. It works when I create two relations between:
- Table_Sale and Table_Time on "Start date"
- Table_Purchase and Table_Time on "Start date"
so when user filter data by "Start date" using slicer (Table_Time.Date) report works correctly, but when user want to filter by "End date" it doesn't work. System doesn't allow to create second relations between Table_Sale and Table_Time on "End date".
Does anyone have an idea how to add passibility to create global filters on two dates (start and end date)?