Parameters - what’s the point

[mp390988]

So in power bi desktop within query editor you can define parameters. But what I don't quite understand is that this is of no use to report users because how will they change the values? 

I don't really see what use they have. 

[Cookistador · Accepted solution]

It can be very useful for data sources 

Imagine you have une data source using dev and the other one using prod 

Instead of opening power query to change the data source, you can use parameters 

And the best, you can switch them directly in power bi services (manually or with deployment pipelines)

It can be also useful to only export a batch of your dataset for dev purpose and once everything works, you can modify it to return the whole dataset 

The use of parameters is unlimited but probably a little bit more advance topic

[v-prasare]

Hi @mp390988,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

Hi @mp390988,  As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

Hi @mp390988, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

@nvprasad & @Cookistador , Thanks for your promt response

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[nvprasad]

Hi,

You can change values from slicer as well. 

Please refer to below link from Microsoft.

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

[Cookistador · Accepted solution]

It can be very useful for data sources 

Imagine you have une data source using dev and the other one using prod 

Instead of opening power query to change the data source, you can use parameters 

And the best, you can switch them directly in power bi services (manually or with deployment pipelines)

It can be also useful to only export a batch of your dataset for dev purpose and once everything works, you can modify it to return the whole dataset 

The use of parameters is unlimited but probably a little bit more advance topic

[WishAskedSooner · Accepted solution]

@Cookistador,

Let's say you design a Report where Users can plot Sales versus Date, Product, and Store. Ordinarily, that requires three different plots.

Now, you want to collapse those three plots into a single plot and put Date, Product, and Store into a slicer. Well, parameters are the answer.

There are other more non-intuitive ways to accomplish the above task, but that is the most basic use case for parameters. And, there are lots of videos that walk through exactly that.

[mp390988]

Hmmm not sure if this makes sense.

date, product and store are 3 different dimensions so I cannot visualise how you would put all this into a single parameter.