Setup parameters for the users on the report

[Anonymous]

Hi all,

I want setup parameters for the users on the report.

Somebody have a solution please ?

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

You could create paramters in Query Editor and then save the report as a templates. Onece users open the report, it will pop up a parameter window that need to be filtered by users.

For more detals, you could reference the blogs below.

Deep Dive into Query Parameters and Power BI Templates

Using Parameters in Power BI

Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4

Best Regards,

Xue Ding

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

[Anonymous]

Hi,

Thank you for your answer, but I have another question about it.

I have a table with data from city, how can I apply my parameter to this ?

[Anonymous]

Ok, I found it.

This is not practical because you always have to refresh the data, is there a solution to automate all this?

Regards.

[Anonymous]

And it's work only on Power BI desktop ?

[v-xuding-msft]

Hi @Anonymous ,

1. In the Desktop, it's impossible to refresh automatically. We need to fresh manually after changing parameters. 

2. We can also use parameters in Service. For more details, you could learn from the video.

https://www.youtube.com/watch?v=zeeiSFdWCrY

Best Regards,

Xue Ding

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

[Anonymous]

Hi,

Ok, thank you ! 

regards.

[Anonymous]

up