I have daily sales data in my data model.
Have a pivot table on my dashboard that groups sales by area.
Looking to create slicers that will enable the user to choose the start and end dates of the sales data. Slicers will need to go to the "day" level, as users will mostly want to see week over week numbers (I'll have 2 pivot tables - current week and previous week).
Any help would be appreciated!
Thanks!!
Have a pivot table on my dashboard that groups sales by area.
Looking to create slicers that will enable the user to choose the start and end dates of the sales data. Slicers will need to go to the "day" level, as users will mostly want to see week over week numbers (I'll have 2 pivot tables - current week and previous week).
Any help would be appreciated!
Thanks!!
