sharepoint list multvalues filter

[Anonymous]

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

[v-yulgu-msft · Accepted solution]

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