Forum Discussion
How to filter 3 columns with one data segmentation
Hello everyone!
I'm from Argentina, and I have a question for you!
I need to be able to filter data from 3 columns at a time with a single slicer. Is this possible?
For example, I have 3 columns with emails and I want it to show me all the rows that contain an email that I can dynamically filter in any of the columns.
Thanks a lot!
Adrián Solís.-
2 Replies
- amitchandak
Super User
adrileosol , Do you want to filter the same email in different measures?
One way is to join email with a common table having email and two join will inactive, you can activate them using userelationship
Of have table not connected with any of the column and you can measure like
Countrows(filter( Table, Table[email1] in values(email[email] ) || Table[email2] in values(email[email] ) || Table[email3] in values(email[email] ) ) )
Or use three email dimension tables
Hello! Thanks for response!
I dont want to make a mesure.
I only want to filter, with a drop box, a filter visualization.
For example, with products to make it easy:
Product 1 - Product 2 - Product 3
1 Banana Tomato Apple
2 Juice Soup Banana
3 Rice Salad Chicken
4 Apple Banana Coca Cola
I want to select "Banana" in a drop box (Filter - Segmentation) and the result in a table should be the rows 1, 2 and 4.
If i selecet "Apple" the result should be the rows 1 and 4.
I hope i was clear, sorry...
