Forum Discussion

adrileosol's avatar
adrileosol
Regular Visitor
2 years ago

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 w...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

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

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

 

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

  • adrileosol's avatar
    adrileosol
    Regular Visitor
    2 years ago

    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...