Forum Discussion

serargi's avatar
serargi
Advocate II
9 years ago

Change filter using URL

Hello!   I have a shared dashboard and report in powerbi.com. It's shared to more than 30 people   The report has some filters (slicers) like "date", "companyName", "owner"... and nobody wants to...
Need Help
Tips and Tricks
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi serargi,

 

Based on my test, above syntax is correct. In your scenario, please check whether you have configured proper relationship between Users Table and other tables which are referenced in visualizations.

 

Regards,
Yuliana Gu

  • serargi's avatar
    serargi
    Advocate II
    9 years ago

    Hello v-yulgu-msft,

     

    I checked as u told me, and it has correct relationship, but it still not working :/

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

      Hi serargi,

       

      Have you tried to republish the pbix file? If you filter data based on another table/column, does it work? Please note that table and field names are case sensitive.

       

      Could you illustrate how you created the report with some sample data so that I can try to rerpoduce your scenario?

       

      Regards,
      Yuliana Gu

      • serargi's avatar
        serargi
        Advocate II
        9 years ago

        Yes, I replublished the report but it didnt work. I also try to use "ID/ReportSection3?filter=Tickets/Status eq 'done'" but it still not working

         

        I use a grid to show all the tickets. Then two slicers, one for owner and other one for status.

        - Status could be open, waiting or done.

        - Owner is an email address.