Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

sharepoint list multvalues filter

Hello community,

 

I need a help to find a way to filter Sharepoint list multivalue. Looks like a simple scenario but I'm struggling for two days already. I have two colums multivalues, one like ";#Japan;#China;Korea;#India" and another ";#iron;#gold;#silver". I just need a slicer able to filter rows that contains "China,Korea and Gold" or just "China". I found a way to filter one column but the filter that I need has to be able to filter more than one value at once. Can anyone help me? 

 

Thanks all experts,

 

Augusto

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anonymous,

     

    Here is a similar thread for your reference: Power BI Desktop Filter Multi Value Field/Column

     

    Besides, to filter for instance 5G and 7G at the same time, please the steps I applied in Editor Query.

     

    Then, in design surface, you should create a relationship between Table1 and Table2 based on [Value] field.

     

    Result.

     

    I have uploaded the modified .pbis file. Please check the report view on Page2.

     

    Best regards,

    Yuliana Gu

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

     

    Here is a similar thread for your reference: Power BI Desktop Filter Multi Value Field/Column

     

    Besides, to filter for instance 5G and 7G at the same time, please the steps I applied in Editor Query.

     

    Then, in design surface, you should create a relationship between Table1 and Table2 based on [Value] field.

     

    Result.

     

    I have uploaded the modified .pbis file. Please check the report view on Page2.

     

    Best regards,

    Yuliana Gu