Forum Discussion

TJ99's avatar
TJ99
Frequent Visitor
4 years ago

Create Dynamic table based on two text value slicers

Two slicers:

  • Sicer 1 pointing to tPrimaryCustomer
  • Slicer 2 pointing to tMarketCustomer
  • Stand alone tables

 

Scenerio: The user selects a Primary customer (Slicer 1)  and the Market comparison customer(s) (Slicer 2).  Need a table created off of those selections so I can create several measures with the sales data related to those Market customers to do Market comparison and indexing to see over/ under performing the market.

 

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    TJ99 , You can not use slicer values in calculated tables.

     

    You can create a measure and use that in visual or visual level filters

  • TJ99's avatar
    TJ99
    Frequent Visitor
    4 years ago

    OK.  I will come up with another way to architect this than.  Thanks.