Forum Discussion
Parameters - what’s the point
- 1 year ago
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
- 1 year ago
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.
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