Forum Discussion
Slicer based on values from two columns
Try the first part of the below solution:
Simply, you create a table with one column that contains all the numbers from both, Call From and Call To. Then, you drag that column to the slicer.
Hope this helps.
Thanks!
You can unpivot the 2 columns(Call from and Call to) into a single column (lets say Call Type) as well using Query Editor
You can do it with DAX as well i.e. create a separate unpivoted table
Omega - Thank you for the suggestion. I looked at the hierarchy slicer but can't figure out how it fits this use case. The data I'm trying to filter isn't hierarchical. Both columns are phone numbers with no hierarchy between them. Can you help clarify?
If I understood correctly, each "Call From" have a list of "Call To", and you'd like to show both in slicer.
Using a hierarchy slicer, you can show all the "Call From" numbers as parents and underneath each "Call From" you will see the "Call To" numbers.
I'm sorry if this is not what you are looking for :D
I see... its close, but not exactly what I need. I'm looking for a slicer that will filter the data if it is present in either of the two columns. There are many hundreds of thousands of phone numbers in the data, so I've enabled the "search" function in the slicer and what I'd like is to be able to search for a phone number in either the "Call From" or "Call To" fields and if it is found in either of them, then filter all such records. Eg: If I search for 214-546-1802 and it is found in some "Call From" records and some "Call To" records, then it those records should be shown.
I am currently doing this with two separate slicers, one for "Call From" and another for "Call To", but its not elegant.
Try the first part of the below solution:
Simply, you create a table with one column that contains all the numbers from both, Call From and Call To. Then, you drag that column to the slicer.
Hope this helps.
Thanks!