Parameters in Power BI Dashboard | Power Query Editor | Types of Parameters | Practical Case Studies

▶ Download PDF from here

▶ Evaluate yourself if you can become a successful Business Analyst

In this video, I will discuss Parameters in Power BI. What is a Parameter, types of parameters, purpose and limitations of using Parameters in Power BI Reports.

There are various benefits of using Parameters in Power Query, Power BI Desktop, Dashboard, and reports. I will explain all the types one by one in this video.

Some of the definitions:
▶NUMERIC RANGE
With the numeric range slicer and the date range slicer, you can create filters for any numeric or date column in your data model. There are three options for filtering your data:
Between numbers or dates.
Less than or equal to a number or date.
Greater than or equal to a number or date.

▶FIELD PARAMETERS
Field parameters allow users to dynamically change the measures or dimensions being analyzed within a report. This feature can help your report readers explore and customize the analysis of the report by selecting the different measures or dimensions they're interested in.

▶QUERY PARAMETERS
Parameters give you the flexibility to dynamically change the output of your queries depending on their value, and can be used for:
Changing the argument values for particular transforms and data source functions.
Inputs in custom functions.

▶ TIMESTAMPS:

00:00 Parameters
03:55 NUMERIC RANGE
07:30 TOPN Function
12:50 FIELD Parameters
18:00 Parameters in Power Query
20:00 Manage Parameters
26:20 Using Query List in a Parameter

💡 END-TO-END POWER BI DASHBOARD
========================
End-To-End Power BI Dashboard Tutorial for everyone | Data Storytelling in 2023 | Data Visualization

📁 Data Analyst Resume:
================
Data Analyst Resume with No Work Experience | Step by Step Guide | Templates + Tips + Examples

🛑Data Analyst Journey:
=====================
How I would Study Data Analytics in 2023 (If I had to start over) | Schedule | Salaries | Skill Set?

Timetable And Efficient Strategy to Learn Data Analytics while Working | Improve Productivity

💡 LEARN MORE
========================

💡 LET'S TALK
========================
☮Any specific query? Want to get an Interview ready? Ask me anything!

▶ Data Visualization using Power BI in 2023
▶Data Storytelling in Power BI using various graphs
▶Generate insights from the raw data

#powerbi #powerbitutorial

[shreya]

Using TOPN in numeric range was amazing. Thanks for sharing such insights for us.

[Igarpe]

Amazing! Learning a lot from you. Many thanks

[ashokkumarpadmanabhan]

Awesome Video !!! Highly Appreciated your efforts of making and sharing. very Clear Demonstration. Keep videos :) I Learned new things very clearly

[shivyogi]

Good job....please consider creating videos on complex topics

[tinkuraj]

Hi, how can I control query parameters in a slicer from report view?. Here I am trying to merge two duplicate tables ( the inputs for those two tables are based on parameter selected table name since I have multiple tables loaded in power query) to get the compassion and the tables contain same set of columns with different data.. and this is happening in power query and I can able to control the merge from report view on "edit parameters" in transform data drop down. Here my question is how can I show those edit parameters in a slicer?
To give the end user complete control over the tables to merge

[sravanpesari]

I am currently facing one more issue with how to call Oracle stored proc with parameters in Direct Query mode? Appreciate your inputs or any workaround

Thanks

[mnxpwqj]

This is very helpful. Please how do I use a date parameter to select a particular date from a sql query connected to power bi?

[peztvpz]

Sir, good informative video. Can we add this parameter into Dashbaord? If we publish the desktop charts into Power Bi Service, I am unable to add the parameters into Dashboard. Can you please help me to achieve this?

[krishnaRVR]

Thanks for the video. I have one question in query parameters csn we pass multiple values instead of single value?

[bhaskarlahari]

Hi This video was good and easy to understand. I used query parameters to filter the table in power query. Now is that possible to get that parameters as slicer so that the end user can slice the region he wants. I tried to edit parameters in power bi service but it has taken through the dataset settings of parameters but end user will not have access to the dataset to change the settings. but i have a scenario where the end user wants to change the parameters in report in power bi service. is that possible to achieve that.