Parameters issue in Power Bi Report Builder

[jayasurya_prud]

For Paginated reports, I am building a report in Power Bi Report Builder. When I added the Parameters and designed the output, I could see that the Parameters are not interactive. I want my Parameter to be interactive in a way that if i select an option in 1st Parameter, automatically the second parameter should show only the relatable records to 1st Parameter.

For example, 

S.No	First Name	last Name
1	John	Wick
2	will	smith
3	John	david
4	Alan	finch
5	Syed	muhammad
6	George	david

In this, if my 1st Parameter in First Name and If I select John in First name Parameter, the second name parameter should show only Wick and David. If no records are matching, it should not show any options. 

But when I give john, all the options in last name comes out. 

How to make it interactive.

[Anonymous · Accepted solution]

Hi @jayasurya_prud ,

Because parameters are managed independently on the server, republishing a main report with new parameter settings doesn't overwrite the existing parameters settings on the report.

You may refer to:

Report parameters in Power BI Report Builder 

Best Regards,
Community Support Team _ Caitlyn