Create filter from two columns

[Anonymous]

Hello everyone

Im struggeling with something that, in my head, sounds like a very easy task (but isn't with my pbi skills)

To begin with, this is the data structure. I have a sales table, that contains OrderNo, Product, Date, CustomerNo, SalespersonOrder, SalespersonCustomer, amount

The thing is, every salesperson has their own costumers wich they are responsable for, but the specific order can be done be another salesperson. 

It is therefore vital, that we can toggle between sale details from "Customer owner" and "Order Owner". 

Explained in this example with Ben, Tim and Calir as salespersons.

This is the complete table:

Lets say, that I choose Ben in my SalespersonName filter.

When adding another filter "1" (SalespersonCustomer) i want to see: 

And when still having "Ben" choosed in the first filter, I want to see the following, when choosing "2" (SalespersonOrder)

Hopefully it makes sense! 

Thanks in advance

[v-yuta-msft · Accepted solution]

Hi Lahan10,

No complete same solution in power bi but here is a workaround which may work in your senario:

Click query editor-> Transfrom-> Click on column [SalespersonCustomer] and [SalespersonOrder]-> Click Unpivot Columns-> Rename [attribute] and [value]

 

After applied&close, import a custom visual called hierarchy slicer, drag columns [Customer&Order] and [Name] one by one to the slicer.

 

Regards,

Jimmy Tao