Help with creating excel dashboard

Copper Contributor

Hi Team,


I am trying to create an excel dashboard using the following data, which looks at the daily visitor numbers across multiple sites.


The pviot table data being displayed includes total number of visitors per site per month, total breakdown by day per site.


I want to be able to include slicers where users can filter by month and by day - but also want to create customisable dashboard that can easily display the data by just selecting the site from a drop down. 





Any ideas/suggestions would be really helpful! 


This arranged day by day - I want to be able to create a filter or dropdown where the data/dashboard 

2 Replies

@rpra137 If you right-click that date column you should be able to group the dates by days, months and years. Doing so should allow you to add slicers for those intervals


check this 

i hope help you to begin