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

Подписаться 11 тыс.

Просмотров 8 тыс.

50% 1

▶ Download PDF from here
bit.ly/3IgYmXb
▶ Evaluate yourself if you can become a successful Business Analyst
topmate.io/analyticalguy/132311
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
www.youtube.com/watch?v=rhP1k...
📁 Data Analyst Resume:
================
Data Analyst Resume with No Work Experience | Step by Step Guide | Templates + Tips + Examples
bit.ly/3TZIKtG
🛑Data Analyst Journey:
=====================
How I would Study Data Analytics in 2023 (If I had to start over) | Schedule | Salaries | Skill Set?
www.youtube.com/watch?v=MCoZC...
Timetable And Efficient Strategy to Learn Data Analytics while Working | Improve Productivity
www.youtube.com/watch?v=2uhKF...
💡 LEARN MORE
========================
▶ Power BI Playlist -- bit.ly/3U3NVts
▶ Data Analytics Projects -- bit.ly/3hb84zd
▶ Excel Training - bit.ly/3WvCUTs
💡 LET'S TALK
========================
☮Any specific query? Want to get an Interview ready? Ask me anything!
bit.ly/3DB03ex
▶ Data Visualization using Power BI in 2023
▶Data Storytelling in Power BI using various graphs
▶Generate insights from the raw data
#powerbi #powerbitutorial

Опубликовано:

3 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 22

@shreya6115 Год назад

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

@analyticalguy Год назад

Thanks for your kind words, Shreya! 🙏

@Igarpe 9 месяцев назад

Amazing! Learning a lot from you. Many thanks

@analyticalguy 9 месяцев назад

I’m glad you are benefitting from these videos 🙏

@ashokkumarpadmanabhan6483 9 месяцев назад

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

@analyticalguy 9 месяцев назад

Thanks Ashok for your kind words. Hope you will like more such videos, uploading next month!

@shivyogi806 Год назад

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

@analyticalguy Год назад

Thanks for your kind words, Shiv! 🙏

@harshalmahajan6470 Год назад

You are doing great job

@analyticalguy Год назад

Thanks Harshal for your kind words. What else would you like to learn? May I know which language are you learning these days?

@tinkuraj9715 Месяц назад

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

@SagarsDataJourney 7 месяцев назад

Thanks for sharing

@sravanpesari1145 9 месяцев назад

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

@user-pe6zt6vp9z 6 месяцев назад

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?

@pthapa55 6 месяцев назад

Good work. Thanks.

@analyticalguy 2 месяца назад

Thanks for watching!

@user-mn2xp7wq8j Год назад

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?

@analyticalguy Год назад

Hi Chioma, You can add M query in Advance Editor that will filter dynamically according to the Parameter. Did you try this way?

@bhaskarlahari1666 Год назад

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.

@analyticalguy Год назад

For that there are separate parameters on Powerbi desktop that yoj have to use.