Forum Discussion

Wresen's avatar
Wresen
Post Patron
1 year ago

Parameter visualization on published report

Hi and thx for reading this. I have Direct query report with a SQL query with one parameter that retrieves the data of fruits I have in the database (yes it’s a fake scenario 😊) The advanced que...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Wresen ,

 

Thanks for the reply from AgataJ .

 

Power BI does not support entering parameters using dynamic text boxes.

 

In Direct Query connection mode, data is not imported into Power BI Desktop. Instead, Power BI Desktop sends the query to the underlying data source to retrieve the required data.

 

Using the field parameter AgataJ mentioned, you can automatically generate a slicer with more than 20 fruits. When you select a fruit, a query like “Select * from Fruit where fruit = ‘Apple’” is sent to the data source to query for the data you want.

 

If you have any other questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

  • Wresen's avatar
    Wresen
    Post Patron
    1 year ago

    Hi Anonymous 
    Thanks for your answer but like i wrote , i have over 20 miljon diffrent distinct fruits and do an "offline table" in Power Bi for this is not a gooda way for the field parameters .

     

    Thanks.

    (I have alot of diffent fruits 🤣)

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi Wresen ,

       

      Okay, here's another way to do it without using field parameters.

       

      Here's the data I used to test it:

       

      In Power bi desktop Get more visuals>> Search for Text search slicer visual object and click Add to use it.

       

      You can add the Fruit field to the text search slicer and then enter the name of the fruit you want in it. This way, you can filter the data in another visual object and display the relevant content.

       

      The pbix file is attached.

       

      If you have any other questions please feel free to contact me.

       

      Best Regards,
      Yang
      Community Support Team

       

      If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
      If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

      • Wresen's avatar
        Wresen
        Post Patron
        1 year ago

        Hi Anonymous 
        I really appriciate your help, i think i have not been good to explain.
        I dont want to have a table where i have all the fruits (since it over 20 milj distinct fruits) in the report that the user can choose from to get a "fruits parameter"
        I want the user to "free" write the fruit he wants in a "textbox lookalike". This input from this textbox  becomes the Fruits parameter in:
        Where#(lf)#(lf)The_Fruitserver.Fruits_table in ('"&Fruits&"')

        But from what i think i have heard this is not possible.

        /Thanks 🙂