Using Parameters in Power BI
HTML-код
- Опубликовано: 25 июл 2024
- 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.
►► The Starter Guide for The Modern Data Stack (Free PDF)
Simplify the “modern” data stack + better understand common tools & components → bit.ly/starter-mds
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
►► The Starter Guide for The Modern Data Stack (Free PDF)→ bit.ly/starter-mds
Simplify “modern” architectures + better understand common tools & components
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?
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!
Great vid. Super simple to understand. Much appreciated.
Thank you very much! I love it when a video is coherent.
Glad you liked it!
Thank you very much!
Great job - Nice and simple
Thank you! Glad you found it helpful
Finally I understand those parameters. Thank you very much!
Great to hear!
This is one of best video's I have ever seen about Parameters.
Crisp and clear
Thanks a ton for this video 👍
Glad it was helpful!
Good explanation. Bravo!
You showed me the exact concept which i was looking for from the last 2 days...dont know how to thank you enough...#TheSaviour 😎😎
Awesome! Thanks for watching.
Thank you! Very concise and useful
Glad it was helpful!
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
Very useful video . Thanks
Thanks for watching!
Thank you very clear explanation step by step Thank you Kahan!
Glad it was helpful!
Great Explanation
Glad it was helpful!
Can you use the Parameter you created on Power Query Editor on Power BI Desktop as one of the filters?
I really like your teaching method.
Appreciate it. Thanks for watching!
hi kahan, how the user will use this parameters in the service, specially the drop list parameter
Can we use parameters for the data source in power bi for snowflake?
great explanation
Glad it was helpful!
I was stuck! Your video came to rescue (@6:03), Thank you so much :-)
Glad it helped!
very helpful
Thanks for watching!
Hello. Can we filter two values at time. Black and white. Is it possible? If possible how?
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!
Thanks
You're welcome!
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
In the “Filter rows” dialog i cant find the filter by parameter button. Did Microsoft removed it!?
Hmm...I don't believe so. Were you ever able to locate this?
@@KahanDataSolutions thanks for the answer it is actually an option in the power bi desktop settings. Solved!
@@tonyburg Awesome! Glad to hear you were able to resolve that.
Paramétrer 4:57
Paramétrer 5:23
I don't really get why parameters are useful. is it because it speeds up the reports?
Your editing is so jumpy that it distracts from the content of the video. It's good content but could use further editing.
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.