relative values in slicer

[diklaida]

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??

[Anonymous]

@diklaida

Can you make an example of how your data stored?

[diklaida]

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-msft]

@diklaida,

"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