Forum Discussion
Help: Slicers not connecting to pivot tables
Hi everyone, I've been trying to figure this out but to no avail.. attaching my test dataset here.. am trying to use slicers (months) to refresh the 2 charts (gender and age). I've include raw data in...
That's better to create separate table with months (even better to use calendar), add this table to data model, build relationships
and use months from this table both in PivotTables and Slicers.
Thanks very much Sergei for the prompt response! I've tried using just calendar months (Jan, Feb, Mar) but they won't come out in that sequence, instead it will be alphabetical. Any idea how to resolve that?
Better to work with actual dates. In simplest case create table like
add it to data model and in Power Pivot add two columns
and
Select [Month] and Sort By month number
Create 1:M relationships on Month from date column to your other tables. Create PivotTables and use [Month] from Date table in it. It's a best practice to hide field which is on many side of relationship.
I didn't touch your file with above, perhaps it's better to repeat from scratch with Date table.
- Thank you Sergei!! Brilliant advice!
sharon1994 , glad it helped