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

Поділитися
Вставка
  • Опубліковано 26 жов 2024

КОМЕНТАРІ • 22

  • @shreya6115
    @shreya6115 Рік тому +3

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

    • @analyticalguy
      @analyticalguy  Рік тому +1

      Thanks for your kind words, Shreya! 🙏

  • @Igarpe
    @Igarpe Рік тому +1

    Amazing! Learning a lot from you. Many thanks

    • @analyticalguy
      @analyticalguy  Рік тому +1

      I’m glad you are benefitting from these videos 🙏

  • @ashokkumarpadmanabhan6483
    @ashokkumarpadmanabhan6483 Рік тому +1

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

    • @analyticalguy
      @analyticalguy  Рік тому +1

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

  • @harshalmahajan6470
    @harshalmahajan6470 Рік тому +1

    You are doing great job

    • @analyticalguy
      @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
    @shivyogi806 Рік тому +1

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

  • @sravanpesari1145
    @sravanpesari1145 11 місяців тому

    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

  • @RaviAnagani
    @RaviAnagani 8 місяців тому

    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?

  • @tinkuraj9715
    @tinkuraj9715 4 місяці тому

    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
    @SagarsDataJourney 10 місяців тому

    Thanks for sharing

  • @pthapa55
    @pthapa55 8 місяців тому

    Good work. Thanks.

  • @krishnaRVR
    @krishnaRVR Рік тому

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

  • @ChiomaIfunanya-n6i
    @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
      @analyticalguy  Рік тому +1

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

  • @bhaskarlahari1666
    @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
      @analyticalguy  Рік тому +1

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