Forum Discussion
Several Reports using the Same Customer Code
Parameters are specific to a single report.
You may be best storing the customer in a file or database table and then importing this into each report and then building the data from the imported customer.
Patrick at GuyInACubeShow you how to do something like this
https://www.youtube.com/watch?v=iiNDq2VrZPY
thanks
i need the report User to be able to select the customer code from say a drop down ( ala Filters in XLS)
does that make sense?
paul
Yes it makes sense, but it's not possible if you have several powerbi documents.
However if all your reports are in a single powerbi on different tabs/pages you can use parameters
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
What is your source sql? If so you may need to use text manipulation of the SQL to apply the parameter filter
Also if you bring in all the data or use direct connect then you can just use slicers.
The latest version has syncing of slicers across different pages.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2018-feature-summary/
