The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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