I have 2 tables in my data model. One, named 'Data Table', has 4 fields: Date, Index, Category and Value. The other is a calendar. These tables are joined on the Date field.
I have a pivot table which uses my data model and has 2 slicers applied to it: 'Data Table'[Category] and Calendar[Date...