Using Parameters in Power BI

Power BI allows you to use parameters to make your reports and data sources more dynamic.

In my opinion, using Parameters in Power BI is not as intuitive as you would expect, but this video will help clear it up as we walk you through how to use them.

Timestamps:
0:00 - Intro
0:22 Parameter vs Filter
1:05 Add What If Parameter
3:05 Use in a Measure
4:44 Data Source Queries
4:50 Parameter Type - Any
6:10 Parameter Type - List of Values
6:59 Parameter Type - Query
8:59 Edit Parameters
9:25 Recap

Title & Tags:
Using Parameters in Power BI | Power BI Tutorial
#kahandatasolutions #powerbi #dataengineering

[markusher]

This is the best instructional video I've seen to date on how to use parameters in Power BI although, as a Tableau user only now learning Power BI, I have to say that compared to Tableau it is like pulling teeth to set up even a fairly simple parameter-based model in Power BI. For example, I am currently trying to figure out how to set up a parameter in BI that allows the user to switch between using different measure fields in the data source table and see the effect on all the dashboard reports. Specifically, I have purchasing expenditures of thousands of items over different time periods, i.e. fields for CY2019 Amount, CY2020 Amount, CY2021 Amount (plus more for all the quarterly time periods, e.g. CY2020Q1 Amount, CY2020Q2 Amount, etc.). In Tableau I would create a calculated field, say "Period Expenditure", in which the calculation uses IF and ELSE SQL and a parameter called "Selected Time Period" which is a simple text list of all the periods CY2019, CY2019Q1, etc. The user selects the parameter value on the dashboard for the time period, e.g. CY2020Q3, and the calculated field logic causes "Period Expenditure" to be equal to CY2020Q3 Amount. The dashboard now shows how all the reports look for the CY2020Q3 time period. I've been trying to get this done in Power BI and for the life of me can't get it to work. Which one of your options in your video would this correspond to?

[maxmeista]

Awesome definition (filter vs parameter). I was asked this recently, gave a long spiel, but this is concise and straight to the point. Thank you, sir!

[bero]

Thank you very much! I love it when a video is coherent.

[marine]

Finally I understand those parameters. Thank you very much!

[udayshankarnellore]

This is one of best video's I have ever seen about Parameters.
Crisp and clear
Thanks a ton for this video 👍

[surajrawat]

You showed me the exact concept which i was looking for from the last 2 days...dont know how to thank you enough...#TheSaviour 😎😎

[ChrisSmithFW]

Great vid. Super simple to understand. Much appreciated.

[marounsader]

hi kahan, how the user will use this parameters in the service, specially the drop list parameter

[danlschmenkeman]

Nice video, Kahan! ...I'm working on some kind of project dashboard. There is a slicer on the report that you can use to select the project. Question: Can it pass on the project ID from the slicer selection as a query parameter so that the SQL query is always supplemented with "where ParameterProjId" and queries the data of the selected project (direct query)? Thanks!

[yig]

Thank you very clear explanation step by step Thank you Kahan!

[tomasjezek]

Is it possible to change values of the parameters for data source queriing in published Power BI report (I am using version (PBI Desktop/Server) January 2021 and can not update it). Thanks

[anismairi]

I still have an issue because when i do this and publish the report in the pbi service, i cant refresh the report.. it indicates that it's a dynamic data source and the refresh is not allowed in pbi service. Any solution ?
thank you for the tutorial

[jraymer]

Thank you very much!
Great job - Nice and simple

[g.janardhanreddyjanardhan]

Hello. Can we filter two values at time. Black and white. Is it possible? If possible how?

[Koreafut]

Can you use the Parameter you created on Power Query Editor on Power BI Desktop as one of the filters?

[unick_gul]

Can we use parameters for the data source in power bi for snowflake?

[tonyburg]

In the “Filter rows” dialog i cant find the filter by parameter button. Did Microsoft removed it!?

[LawOfNewton]

I don't really get why parameters are useful. is it because it speeds up the reports?

[Blahnik]

The content is fantastic, but your editing needs work. It's really hard to listen and watch when the video looks and sounds so glitchy.

[Blahnik]

Your editing is so jumpy that it distracts from the content of the video. It's good content but could use further editing.