Log In
Register
Home
November 26, 2020
Offline
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.
See Answer
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
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)
Answers Post
1 Guest(s)
