Using Parameters in Power BI 

►► Establish a Well-Structured Data Warehouse for Your Small Team In 90 Days (Free Guide) → www.kahandatasolutions.com/guide

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!

Finally I understand those parameters. Thank you very much!

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

Thank you! Very concise and useful

Great vid. Super simple to understand. Much appreciated.

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

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

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

Thank you very much! Great job - Nice and simple

I was stuck! Your video came to rescue (@6:03), Thank you so much :-)

Good explanation. Bravo!

I really like your teaching method.

Great Explanation

Very useful video . Thanks

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

very helpful

Thanks

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

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

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

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

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

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

Paramétrer 4:57

Paramétrer 5:23

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

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

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.

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