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?
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
Hi, I have added two aggregated fields called dollar and sales in a field parameter, used it in a filter and added it value fields so basicially the visuals can switch as per the filter but do i use them in ytd calculation without a date table
I have a paginated report that dynamically selects the groupings based on the user's selections. There are four levels of groups each with their own parameters - although the parameters are identical and based on a query. The parameter has a friendly name as a label and a field as the value, so each of the four groups will be selected in order according to the selected label/field. I know how to make this work in SSRS but don't know how to make it coordinate with parameters in Power BI. Any suggestions?
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!
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
![ประสบการณ์ จ้าง Developer ที่ผมจะไม่มีวันลืม [ภาค2]](http://i.ytimg.com/vi/pZbsSDRrmXA/mqdefault.jpg)
Looking for help with your team's data strategy? → www.kahandatasolutions.com
Looking to improve your data engineering skillset?→ bit.ly/more-kds
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!
Thank you very much! I love it when a video is coherent.
Glad you liked it!
Finally I understand those parameters. Thank you very much!
Great to hear!
Thank you! Very concise and useful
Glad it was helpful!
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!
Great vid. Super simple to understand. Much appreciated.
hi kahan, how the user will use this parameters in the service, specially the drop list parameter
Thank you very clear explanation step by step Thank you Kahan!
Glad it was helpful!
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.
Good explanation. Bravo!
I really like your teaching method.
Appreciate it. Thanks for watching!
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
Hi, I have added two aggregated fields called dollar and sales in a field parameter, used it in a filter and added it value fields so basicially the visuals can switch as per the filter but do i use them in ytd calculation without a date table
I was stuck! Your video came to rescue (@6:03), Thank you so much :-)
Glad it helped!
Hello. Can we filter two values at time. Black and white. Is it possible? If possible how?
I have a paginated report that dynamically selects the groupings based on the user's selections. There are four levels of groups each with their own parameters - although the parameters are identical and based on a query. The parameter has a friendly name as a label and a field as the value, so each of the four groups will be selected in order according to the selected label/field. I know how to make this work in SSRS but don't know how to make it coordinate with parameters in Power BI.
Any suggestions?
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!
great explanation
Glad it was helpful!
Can we use parameters for the data source in power bi for snowflake?
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?
Thank you very much!
Great job - Nice and simple
Thank you! Glad you found it helpful
Very useful video . Thanks
Thanks for watching!
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
very helpful
Thanks for watching!
Paramétrer 4:57
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 5:23
Thanks
You're welcome!
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.