Help: Slicers not connecting to pivot tables

Copper Contributor
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 the 2 tabs within as well, appreciate some help pls, thank you!!
5 Replies

@sharon1994 

That's better to create separate table with months (even better to use calendar), add this table to data model, build relationships

image.png

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?

@sharon1994 

Better to work with actual dates. In simplest  case create table like

image.png

add it to data model and in Power Pivot add two columns

image.png

and

image.png

Select [Month] and Sort By month number

image.png

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