Forum Discussion
Parameters issue in Power Bi Report Builder
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.
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
1 Reply
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