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.

GilbertQ's avatar
GilbertQ
Super User
8 years ago

Hi mhambalek

 

Which direction is your relationship in your data?

 

I would imagine that as long as you are using the Customer Name from your Customer Table in your slicer, then when you click on a Customer Name it should work as expected.

 

If it does not are you able to provide a sample of your data?

mhambalek's avatar
mhambalek
Helper I
8 years ago

Hi GilbertQ,

 

The relationship is working.  Clicking a customer that exists in the tickets table selects the right data.  The problem is the slicer shows ALL customers in the customer table and not just the ones that exist in the tickets table.  There are over 4000 customers showing in the slicer.  I'd like it to only show the ~80 customers that actually have tickets.

 

The relationship is many to one, Support Tickets to Customer and single direction.