cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rogerdea
Helper IV
Helper IV

Report Builder - Display selected parameters on report page

Hello

 

Is it possible to show parameter selections on a report builder paginated report?  e.g.  I have a list of years and as users could be printing out the report, is would be important to know the parameters selected on the report itself.

 

Is this possible?

 

Thanks

4 REPLIES 4
rogerdea
Helper IV
Helper IV

Thanks for the reply, I did as you suggested by entering =Parameters![DateTableYear].Value into a text box, but it's returning #error on the report.

 

My Parameter:

 

rogerdea_1-1673346088160.png

 

Any ideas why?  It correctly changes the text in the box to <<Expr>> so i know it's accepted the code.

 

Thanks

 

 

Use this instead---  replace "DateTableYear" with your parameter name and it'll display your chosen parameters in a text box, separated by commas.

 

=Join(Parameters!DateTableYear.Label, ", ")

Jon-Heide
Microsoft
Microsoft

Yes. In the body of the report, add a text box. 

 

In the textbox, set the expression to =Parameters![NameOfYourParameter].Value

 

That should show the selected value of the parameter within the body of the report. 

Use this instead---  replace "DateTableYear" with your parameter name and it'll display your chosen parameters in a text box, separated by commas.

 

=Join(Parameters!DateTableYear.Label, ", ")

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.