Filter a report using parameters in the URL

[rajendraongole1]

Hi 

I have created a report. we have a requirement to generate filtered url should report in new web brower.

I managed to get the url with proper filter with one categoriacal field in url link but when i tried to select another different category the url is not getting filtered with expected categorical field. Kindly suggest.

Below is the measure written to capture the url par

url par =

 IF(ISFILTERED(V_PROCESS_OVERVIEW_1[SERIAL_NUMBER]), "https://app.powerbi.com/groups/me/apps/ae2/reports/e0ea/ReportSection?filter=V_PROCESS_OVER/SER_NUM ...

another category i am trying to add is Machine_id also from same table V_PROCESS_OVER  selection. 

Kindly suggest if there is some changes that i need to add in above measure.

Regards,

Rajendra

[lbendlin]

Your filter statement needs to result in a boolean True.  you are missing the comparison part.

Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

[rajendraongole1]

I checked the passing parameter as a string but not working as expected.

Thanks for sharing @lbendlin 

[lbendlin]

Did you follow the documentation? How to escape special characters like spaces?

[rajendraongole1]

yes, filter is not working as expected in services. 

link is getting generated but checked all the spaces and special characters to removed. 

[lbendlin]

It is pretty finicky to get this right. Double and triple check everything. The table and column have to exist, they have to have an impact on the data model, all special characters need to be escaped, the comparison logic is limited (like ODATA) etc etc.  Many things can go wrong with this before they go right.