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

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft 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