Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

URL filter not working

I have a Milestone Dashboard that gets filtered based on TagNames column. The report is published in the web.
When I manually select a tag from the dropdown, the dashboard shows the filtered data. 

I have another Schedule View dashboard that shows the schedules for various Milestones and has a similar column called DevMilestoneReference like TagNames to filter data. Both the columns have the same data. 

My formula to construct URLs for each Milestone:
https://app.powerbi.com/groups/562abbda-014a-4f81-a0e8-125809398871/reports/03b92d01-7a56-452c-8042-bae88157a8fd/ReportSectione711b33707bf4bb9e1b3?experience=power-bi&filter=MilestonesXFeatures/TagNames eq '" & [#"ISG-ES Sensors SharePoint List.DevMilestoneReference"] & "'

For example. when TagName is SCD, the link looks like:
https://app.powerbi.com/groups/562abbda-014a-4f81-a0e8-125809398871/reports/03b92d01-7a56-452c-8042-bae88157a8fd/ReportSectione711b33707bf4bb9e1b3?experience=power-bi&filter=MilestonesXFeatures/TagNames eq 'SCD'

And when the same link is pasted in web, it looks like:
https://app.powerbi.com/groups/562abbda-014a-4f81-a0e8-125809398871/reports/03b92d01-7a56-452c-8042-bae88157a8fd/ReportSectione711b33707bf4bb9e1b3?experience=power-bi&filter=MilestonesXFeatures%2FTagNames%20eq%20%27SCD%27


But the data is not filtered for SCD. Not sure why my filter in the URL is not working!

I did come across a few solutions that talked about using escape character in case of space between field name but that's applicable here. 

Any help is appreciated!



  • Hi,

     

    If the report is publish to web, it will not work. It's one of the limitation. 

     

     

2 Replies

  • Kaviraj11's avatar
    Kaviraj11
    Solution Sage

    Hi,

     

    If the report is publish to web, it will not work. It's one of the limitation. 

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Oops didn't know that. Thanks!