Forum Discussion

Cacaue's avatar
Cacaue
Frequent Visitor
3 years ago

Dinamic report with params

I have created a report with a direct query that show the values that I need according to the parameters created. If I change the value of the parameters in design it changes the values of the report...
Need Help
v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, Cacaue 

 

Now, to pass a new value for the parameter through the URL, you need to append the following query string to the report URL:

?filter=VisualName/ParameterName eq 'NewValue'

 

Replace "VisualName" with the name of the visual that contains the parameter, "ParameterName" with the name of the parameter, and "NewValue" with the new value you want to pass.

 

For example, if the visual is named "Sales by Region" and the parameter is named "Region", and you want to pass the value "West", the URL would look like this:

https://app.powerbi.com/groups/me/apps/xxxxxxx-c4c4-4217-afd9-3920a0d1e2b0/rdlreports/xxxxxxx-639e-4...?filter=Sales%20by%20Region/Region%20eq%20'West'

 

Note that you need to encode spaces in the visual and parameter names as "%20".

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.