Number1One
New Member
- Joined
- Mar 1, 2019
- Messages
- 16
- Office Version
- 365
- Platform
- Windows
Hi All,
Have some data with 500+ products 100 suppliers over time - Have made a Dashboard to show various performance metrics - With slicers to make it interactive for the user.
Issue arise when a few of the charts are showing the worse 15 of top 15 products/Suppliers. Currently there is a value filter on the pivot which shows the top 15 products - When someone selects a product from the slicer this overrides the value filter showing info from that product which is fine - But when the filter on the slicer is removed the top 15 is no longer there and the pivot hits the 255 chart objects barriers and shows nothing useful.
Only thing i can thing of is have a dashboard thats non-interactive on products and suppliers flagging things - and another which is interactive but simpler for looking at specifics. Although this will make whole file etc bigger and slower.
Any other ideas?
Have some data with 500+ products 100 suppliers over time - Have made a Dashboard to show various performance metrics - With slicers to make it interactive for the user.
Issue arise when a few of the charts are showing the worse 15 of top 15 products/Suppliers. Currently there is a value filter on the pivot which shows the top 15 products - When someone selects a product from the slicer this overrides the value filter showing info from that product which is fine - But when the filter on the slicer is removed the top 15 is no longer there and the pivot hits the 255 chart objects barriers and shows nothing useful.
Only thing i can thing of is have a dashboard thats non-interactive on products and suppliers flagging things - and another which is interactive but simpler for looking at specifics. Although this will make whole file etc bigger and slower.
Any other ideas?