Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Multi filtering on different tables in the URL filter

Hi Expert

 

Can someone confirm if the following is possible within Power BI. we are trying to filter two tables by passing a URL filter from Power BI Services, I am able to see examples of filters being applied to several fields from the same table, but I am not able to confirm that you are able to add filters for different tables in the same URL?

 

 

Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ,

     

    Sorry,just now I misunderstood what you said, I thought you wanna filter different tables on different pages, if so,it's unavailable currently,but if you wanna filter different tables on the same page, it's okay.

    You can use the following format to acheive what you need.

     

    //At the end of the URL , just add ?fiter Table/City eq 'beijing' and Table2/Area eq '1200'

     

     

    https://app.powerbi.com/groups/75c43621-6d3b-41f8-ba52-f88c47fa923d/reports/8c23fb48-aa3a-4fa7-b2e3-d0fbd83e6dfd/ReportSection?fiter Table/City eq 'beijing' and Table2/Area eq '1200'

     

     

     

    For the reference,pls refer to :https://docs.microsoft.com/en-us/power-bi/service-url-filters#filter-on-multiple-fields

     

    Best Regards,

    Kelly

     

     

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Kelly

      thanks for the feedback, so based on your asnwer back. even if we have the same pbix file and both tables are in the same tab, and published to PBI Services, we cannot filter both tables using the same URL???

       

      even if both tables have common columns ie. Document ID and Effective Date.....

      • v-kelly-msft's avatar
        v-kelly-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        Sorry,just now I misunderstood what you said, I thought you wanna filter different tables on different pages, if so,it's unavailable currently,but if you wanna filter different tables on the same page, it's okay.

        You can use the following format to acheive what you need.

         

        //At the end of the URL , just add ?fiter Table/City eq 'beijing' and Table2/Area eq '1200'

         

         

        https://app.powerbi.com/groups/75c43621-6d3b-41f8-ba52-f88c47fa923d/reports/8c23fb48-aa3a-4fa7-b2e3-d0fbd83e6dfd/ReportSection?fiter Table/City eq 'beijing' and Table2/Area eq '1200'

         

         

         

        For the reference,pls refer to :https://docs.microsoft.com/en-us/power-bi/service-url-filters#filter-on-multiple-fields

         

        Best Regards,

        Kelly