Forum Discussion

mhambalek's avatar
mhambalek
Helper I
8 years ago
Solved

How to Create Slicer Using Name and Not ID

I have two tables - a Support Ticket table and an Customer table.  The Customer table has ID as a key and name as a column.  The Support Ticket table has ticket # as a key and Customer ID as a column...
Need Help
  • mow700's avatar
    mow700
    8 years ago

    Consider adding a calculated column to your support ticket table to contain the related customer name like:

    Customer Name = RELATED('CustomerTable'[Customer Name])

    Then use this column in your slicer visual.

mow700's avatar
mow700
Resolver I
8 years ago

Consider adding a calculated column to your support ticket table to contain the related customer name like:

Customer Name = RELATED('CustomerTable'[Customer Name])

Then use this column in your slicer visual.

mhambalek's avatar
mhambalek
Helper I
8 years ago

Thanks mow700.  Just what I needed.

 

GilbertQ, that actually helps me with another issue I have.  Thanks.