Interconnected Slicers Filtering Issue

jpc.pablo.1995

New member
Joined
Jul 22, 2016
Messages
2
Reaction score
0
Points
0
Hi,

I actually have a report where there are three pivot charts.

Here are the details:

First Chart- Shows the daily progress of a user
Second Chart- Shows the weekly progress of a user
Third Chart- Shows the breakdown of the user's progress (points)

I made four slicers which are connected right now:

Week
Date
User ID
Evaluation

My problem is this, whenever I click the week in the slicer together with the date it's automatically filtered, the data that is only shown is the data that I selected.

How can I do it that each slicers are still connected and here what I want to do:

On the first chart, I want to show the data for the entire week (I already used the Week in the filed list as an axis field)
On the second chart, Ill be able to show the weekly data
On the third chart, to show the data for the entire week (I already used the Week in the filed list as an axis field)

Thanks.
 

Attachments

  • Capture1.PNG
    Capture1.PNG
    76.2 KB · Views: 11
cross posted without links:

For your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184

ps. The same applies to your other recently started thread here too.

Members are invited to not answer this thread as long as links have not been added - Thx
 
Thanks for adding the link

Could you please post a real sheet instead of a picture?
 
Back
Top