Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Building out paginated reports in Report Builder and I need to filter on multiple tables with one parameter. I have a Customer fact table and a Notes dim table. They have a Customer Id in each table and I need to bring in only the notes from the dim table that is filtered on the customer ID from the Fact table. Right now it is currently bringing in all the notes in the table. This is pulling in data from a Power BI dataset. Any help on this would be greatly appreciated. Thank you!
Solved! Go to Solution.
Hi @MCubedMama ,
You can follow the steps below to get it:
1. Create a parameter CustomerID
How To Create Parameters In Power BI’s Report Builder
2. Modify the query adding with parameter in Query Designer for every dataset
WHERE CustomerID = @CustomerId
Bet Regards
Hi @MCubedMama ,
You can follow the steps below to get it:
1. Create a parameter CustomerID
How To Create Parameters In Power BI’s Report Builder
2. Modify the query adding with parameter in Query Designer for every dataset
WHERE CustomerID = @CustomerId
Bet Regards