How To Use Query Parameter In Power BI [2023 Update]

In this tutorial, Sam shows how to use the query parameter feature inside of Power BI. You can bring significant scale to your reporting by using this feature without the need for duplicated reporting. Build a model once and then use this to add additional filters to your reports.

*****Video Details*****
00:00 Introduction
00:24 Query parameters
01:54 Creating a parameter
02:48 Integrating a Parameter into a query
04:50 Dealing with blanks in the table

***** Learning Power BI? *****

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #PowerQuery #PowerQueryTutorial

[Slate-Mate]

what if users wants to filter out ? as a developer you can edit this but how user will change ?

[dqfxowe]

Hi and thanks for the educational video, sorry if this is a silly question, but is there a way to feed the parameter on the report page? to give User the option of selecting that parameter? for example for selecting two dates and then return the report for them based on the combination of those dates, which doesn't work with slicers for my report.
Thanks

[bhaskaraggarwal]

Thanks. This is awesome✨ Quick question - Any idea, how can this be used on Power BI Service URL filters?

[williamarthur]

Can you load a pq parameter into PBi to use in a measure, my Pbi parameter dialog box has never worked after much trying / reinstalling, so thought this might be a way round the problem.

[uemspxw]

Hi Sam,
thanks a lot for your videos. I learned a lot!
I have a case where I need to do some multi-step calculation based on user input (selections in slicers) and at the end I would like to automatically filter a table based on the calculation result.
The way I started out, the calculation result will end up in a measure. Can I get that measure into the filter criteria instead of a parameter to automatically filter the table?
If yes, how? If no, is there another way?

[friendlyfire]

Question:
Using your example, lets say each resident is only allowed to see their own State Data. -How would a FL user open this Power BI Dashboard to only see their own state simply opening the DB Visualization?
Thank you for this walk through.
Subbed.

[moizalim-b]

Thanks For this amazing trick. But I want to make it Dynamic for my End users on the Report, How can I do that ? BY using slicer, I want my end user to change date or location etc.? please make a video on it.

[azfunbegins]

what if we want to show all data in that parameter option for dashboard i.e:- including all cities name.

[pthapa]

Hi Sam, I have a question for you. I have parameters startdate and enddate in my report. The parameters will work fine in the desktop but when I published the report in service, the parameters will show under settings however the report will not update after changing the values of those parameters. Can you please guide me why it is not working? Appreciate your time. Thanks

[RakamXela]

Im confused, in this example there is still no difference using a paramater and just altering the filter? Can you call or change the parameter from the front end with Dax? Or is it more intended to have multiple tables using parameters? Im not sure I understand the benefot of parameters from this. Love the content though, just this one confuses me.

[zhuldyzamirbekov]

How can we pass a value to Location parameter from url of public report?

[personalfinance]

Few questions here:
How to update query after report is hosted on PowerBI server or service. Do we need to open report in PowerBI desktop, update report and upload again?. How can we do this without opening in PowerBI desktop?

[kpmimrw]

Silly question from an absolute new beginner : how is this any different from a normal filter? The steps applied here, can't it just be done with a regular filter and you end up with the same result? What am I missing?

[mjtr]

Instead of filtering the query in power query, is it not easier to create a slicer of state code?

[pascaljoly]

from your video, it looks like you'd always have to get back into Power Query to then select a new parameter. can't you put the list of state codes in your example in Excel where you'll select the state code and link this to the output of the query? so that you don't have to go back to Power query every time you want to change the state code

[michaeldoyle]

Why do you want all those round-trips to the source data? Doesn't make sense .... The obvious need here, as stated by other below, is for a parameter that can be set to run across many reports and be incorporated as a filter, preferably set by a slider..