Forum Discussion

k3rz0rg's avatar
k3rz0rg
Advocate III
1 year ago
Solved

Power BI report URL filter not working!

Hi everyone,    one of my old project which had report url with filter pointed to another report and that used to work fine but recently I noticed it is no longer working and the format of the repo...
Need Help
  • ibarrau's avatar
    ibarrau
    1 year ago

    Hi. The power bi traditional url has changed. Now it has a parameter at the end. The "experience = powerbi". The way URL works, when the "?" starts it means you will define parameters next. It can only contain one question mark. After one parameter you can add any other with "&" symbol. Check your URL and replace the ? for & like:

    https://app.powerbi.com/groups/[group_id]/reports/[report_od]?experience=power-bi&filter=Table/Column eq 'PA'

    I hope that helps,

ibarrau's avatar
ibarrau
Super User
1 year ago

Hi. The power bi traditional url has changed. Now it has a parameter at the end. The "experience = powerbi". The way URL works, when the "?" starts it means you will define parameters next. It can only contain one question mark. After one parameter you can add any other with "&" symbol. Check your URL and replace the ? for & like:

https://app.powerbi.com/groups/[group_id]/reports/[report_od]?experience=power-bi&filter=Table/Column eq 'PA'

I hope that helps,

k3rz0rg's avatar
k3rz0rg
Advocate III
1 year ago

Hi ibarrau ,

 

thank you for your prompt response and your solution appears to be working. That & and single quote info was I was missing. 
I have couple of questions, if I had multiple filters, should I keep on adding those with & or there's limitation on that? And the other one is, I use the following code where if nothing is selected, it will select max value or min value by default from the slicer, (I'm using this in button), is there any way to set all by default?

SELECTEDVALUE('Transaction'[State], MAX('Transaction'[State]))
 
Thanks!