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