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
AgataJ's avatar
AgataJ
Helper II
1 year ago

Hi Wresen ,

If I understand it correctly, you could create separate DAX parameters for Fruit=Banana, for Fruit=Apple etc, and then create Use Modeling-New Parameter-Fields option, add your DAXes to it. Next, use this parameter for a chart and for a separate slicer. This way the user will be able to decide which fruit they want to see, as a single or combined value.

 

Hope this helps.

Kind regards,

Agata

 

If this post helps, then please consider to Kudos it and Accept as the solution and Kudos to help the other members find it more quickly!

  • Wresen's avatar
    Wresen
    Post Patron
    1 year ago

    Hi AgataJ 
    Thx for your answer.

    Yes its possible to do an "offline" table ( a table where i add all the fruits that i have in the database) and then link that table the to the parameter and put it in a slicer.
    The problem is that i have over 20 miljon diffrent fruits 😆 in the database so i dont think that is an option.

    What i am looking for is like an textbox where i can write Apple , press enter and the query uses my "new" parameter "Apple" and do the SQL query and look for a match.

     

    /Thanks