Forum Discussion

diklaida's avatar
diklaida
New Member
9 years ago

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 ...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

diklaida

 

Can you make an example of how your data stored?

diklaida's avatar
diklaida
New Member
9 years ago

if i filter only 2011 and i add slicer for customer name i wish to see in the slicer only lulu

 

customerssalesyear
lulu4002011
bubu2002013
gogal3002014
lulu4002014
bubu2002013
gogal3002014
  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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