Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
114
Views
Topic starter
Hello,
The attached file is built using Power Pivot. I have created sorting tables and multiple slicers.
1. I need help with the month slicer, as it is sowing all months from Jan-22 to Feb-24. I only want to see the names of 12 months.
2. I have created a chart in the worksheet TrendPivotMax. For a dynamic chart, I would like to get one Min / Max value in the Pivot table across the rolling time period. The aim is to remove the manual formulas.
I have includes the PowerPivot table as worksheets also as reference.
Thank you for the support.
DJ
Posted : 15/03/2024 10:15 pm
The file attachment didn't come through. Please try again and this time don't forget to press the 'Start Upload' button and wait until it's finished before submitting your reply.
Posted : 16/03/2024 2:43 am
