Forum Discussion
Dynamic Parameters in PBI Report Builder using a published dataset
Hi v-kkf-msft
Thank you for taking the time to reply to me
Do I need to do these parameters as a separate dataset or do I try and add it into the DAX query already there? below is a screenshot of the current DAX query (there is a parameter of 'Job No' already there
What I am trying to do is if the user selects 'Job No' in a 'consolidate by' parameter, then enters a valid job number it should then run these columns associated with the 'Job No' - simarlarly, if they select HAWB or Invoice Number
(then enter a vald HAWB or Invoice Number) they will get the details associated with that HAWB or Invoice Number.
This is how the parameters look to the user in SSRS and that I am trying to replicate in PBI Report Builder
Thanks again
- Anonymous3 years agoNot applicable
miss_stoat did you figure out this? I am an SSRS user as well and I have been trying to figure out how to do this i power bi as well.