Forum Discussion
Wresen
1 year agoPost Patron
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...
AgataJ
1 year agoHelper II
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!