Forum Discussion
relative values in slicer
tables for sales per customer
and slicer for customer name
I want to see in the slicer only the customer which have value in the table (sales value) and not all the possiable customer ever opened
is there a way??
3 Replies
if i filter only 2011 and i add slicer for customer name i wish to see in the slicer only lulu
customers sales year lulu 400 2011 bubu 200 2013 gogal 300 2014 lulu 400 2014 bubu 200 2013 gogal 300 2014 
v-caliao-msftMicrosoft Employee
"if i filter only 2011 and i add slicer for customer name i wish to see in the slicer only lulu"
Did you filter your data by using page filter?
If that is the case, slicer items will changes dynamically based on the filter. The thing you need to do is that use customers column in your sales table in slicer.
Regards,
Charlie Liao
