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.

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi mhambalek,



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.  I have a relationship between the two tables using the ID.

As long as the relationship between the Customer table and Support Ticket table is properly set, you should be able to simply use the Customer Name from your Customer Table as a slicer, and then when you select Customer Name it should work as expected.

 

Could you share a sample pbix file(with just some sample/mock data) which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.:smileyhappy:

 

Regards