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

[@shreya6115]

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

[@analyticalguy]

Thanks for your kind words, Shreya! 🙏

[@Igarpe]

Amazing! Learning a lot from you. Many thanks

[@analyticalguy]

I’m glad you are benefitting from these videos 🙏

[@ashokkumarpadmanabhan6483]

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

[@analyticalguy]

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

[@sravanpesari1145]

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

[@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?

[@shivyogi806]

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

[@analyticalguy]

Thanks for your kind words, Shiv! 🙏

[@RaviAnagani]

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?

[@analyticalguy]

Yes you can, Krishna.

[@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

[@ChiomaIfunanya-n6i]

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?

[@SagarsDataJourney]

Thanks for sharing

[@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.

[@pthapa55]

Good work. Thanks.

[@analyticalguy]

Thanks for watching!