Forum Discussion

serargi's avatar
serargi
Advocate II
8 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
8 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
8 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
    8 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
      8 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.

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

        Hi serargi,

         

        Unfortunatelly, I was not able to reproduce your problem. If possible, and if you connected to data source with import mode, you could send me the .pbix file so that I can test in my environment.

         

        Regards,
        Yuliana Gu