Forum Discussion
Post PartisanParameters - what’s the point
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.
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
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.
7 Replies
- Cookistador
Super User
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
WishAskedSoonerContinued Contributor
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.
mp390988Hmmm 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.
nvprasadSolution Sage
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
v-prasareCommunity Support
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
- 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