Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create filter from two columns

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, tha...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    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

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

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