URL error

[Anonymous]

Hi Expert

I am trying to add from the Fact_Sales table column SalesPerson as a filter to my url.....the url has been added to the main fact table as a column meaure...

Link = "https://app.powerbi.com/groups/6a4fa620-97e6-425b-ba79-1c9b9c209e68/reports/4fd1cae2-9326-4fb6-8e98-68399e370188/ReportSection4b0c446f1572368f03a6?filter=Fact_Sales%252FSalesPerson%20eq%20%27″&Fact_Sales[SalesPerson]&”%27”"

when i click on the link sign next to each name in BI services i keep on getting the same name i.e. sales person coming up irrespective of which hyperlink i click...

not sure whati am doing wrong..

this is what i am following as an example..

Link = “https://app.powerbi.com/groups/me/reports/6ea11c00-85ca-4b8e-907a-42979eaadcaa/ReportSection1?filter=CardDetails%252FExpType%20eq%20%27″&CardDetails[ExpType]&”%27”

In the above function we have put the ASCII values for blanks, apostrophes and equal to sign for ensuring that the URL works efficiently

• Blank -> %20
• Equal -> %252
• Apostrophe -> %27

[v-cherch-msft]

Hi @Anonymous 

Please  read the Filter a report using query string parameters in the URL article.You may check if below posts could help.

https://powerbi.microsoft.com/en-us/blog/power-bi-report-url-filter-improvements/

https://community.powerbi.com/t5/Service/Report-Custom-URL-Filter-not-working/td-p/145397

Regards,

[Anonymous]

many thanks,  support team. much appreicated for the feedback.