Forum Discussion
How do I filter the second parameter based on the first parameter in Power BI Report Builder?
What you are looking is cascading parameters effect.
To read and understand: https://docs.microsoft.com/en-us/power-bi/guidance/paginated-report-cascading-parameter
I saw your .rdl file, pls change these only to Dataset2
Query:
SELECT * FROM Sheet1$ WHERE [Sheet1$].Nationality = @Nationality"Dataset 2" Parameters:
and try running the report.
hope this helps!
What you are looking is cascading parameters effect.
To read and understand: https://docs.microsoft.com/en-us/power-bi/guidance/paginated-report-cascading-parameter
I saw your .rdl file, pls change these only to Dataset2
Query:
SELECT *
FROM Sheet1$
WHERE
[Sheet1$].Nationality = @Nationality
"Dataset 2" Parameters:
and try running the report.
hope this helps!
Thanks for your help on the paramters before. I actually tried working on three parameters today after reading the guidance you shared. I was find with one parameter, then two worked fine. As soon as I got to the third parameter I hit a brick wall. I shared the problem here:
https://community.powerbi.com/t5/Desktop/Cascading-Report-in-Power-BI-Report-Builder-Causing-Errors/m-p/2478411#M883027
feel free to take a look if you like.You cannot have NAME as parameter. It is a reserved word.
Try changing to "Param_Name" or "NAME1" and keep the prompt as "Name"
apply to the dataset filter the same change and see if it works!
