Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

URL Filter Parameter Not Working

Hi, I am having an issue passing parameters in a report URL. I am following the documented format:  URL?filter Table/ColumnName eq 'value' but I get error 404 (see image below). The report works wit...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago
Hi Yuliana,
 
Thank you for responding!
 
I copied the report URL from my Workspace and placed it in the following measure:
 
 
Then, I used the following formula to calculate the report filter:
 
Subproject Filter =

Var SubprojectURL = [Subproject URL]

RETURN
    IF(AND(
            ISFILTERED('ViewProjects'[Project Name]),
            NOT(ISBLANK(SELECTEDVALUE('ViewProjects'[Project Name])))
        ),
        // THEN
            SubprojectURL &
            "?filter=" &
            "ViewProjects/Project_x0020_Name" &
            " eq " &
            "'" &
            SELECTEDVALUE('ViewProjects'[Project Name]) &
            "'"
            ,
        // ELSE
            SubprojectURL
    )
 
I then placed the measure "Subreport Filter" in a table.
 
Please let me know if you see anything wrong in my formulas.
 
Thank you!
 
 
Regards,
Carlos Tortoledo
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

 

Please set the data category for measure [Subproject Filter] to "Web URL". Besides, please copy the report URL appended with query string parameter into web address to check if it works, similar to below, replace 'xxxx' with a specific project name.

?filter=ViewProjects/Project_x0020_Name eq 'xxxx'
 
Best regards,
Yuliana Gu