Forum Discussion

mp390988's avatar
mp390988
Post Partisan
1 year ago
Solved

Parameters - 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'...
  • Cookistador's avatar
    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

  • WishAskedSooner's avatar
    WishAskedSooner
    1 year ago

    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.