Jun 06, 2023 Slicers not connecting to pivot tables - HELP! Hello! I am building my knowledge in pivot tables and building interactive dashboards. At the very end of my dashboard, I am unable to connect my slicer to all the pivot tables. I am unsure why! I h...Show ...
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 scrat...
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 ...
We use optional cookies to improve your experience on our websites, such as through social media connections, and to display personalized advertising based on your online activity. If you reject optional cookies, only cookies necessary to provide you the services will be used. You may ch...
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...Show More Testing Dashboard 2.xlsx243 KB Excel Reply ...