Forum Discussion
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
- Kaviraj11Solution Sage
Hi,
If the report is publish to web, it will not work. It's one of the limitation.
- AnonymousNot applicable
Oops didn't know that. Thanks!