I have a data with 1k rows with 20 plants servicing for different customers. My requirement is to filter top 5 plants where the revenue is on the higher side to show in my Dashboard. In the Dashboard, I am showing slicers for Customer, Plant and Division. From the Plant slicer (where already the filter is set to top 5), if I choose any plant and unfiltered, all the plants' data are coming in the chart which I dont want. Please find attached a sample data.
Please let me know how to fix the filter to my choice in PT thereby, it is not affecting the Slicer in Dashboard.
Hi Lakshmipathi,
You can''t use both, If you want top 5, don't use the slicer, what''s the point of having a slicer when only 5 values are listed?
disconnect that pivot table from the Plant slicer. (right click-Report Connections-uncheck plant)
Thank you very much for confirming my understanding is correct.
