Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

5 REPLIES 5
bhenson
Regular Visitor

I know that this thread is old but I finally solved the issue.
=Parameters!YourParameterNameHere.Value(0)
Use that for if you only expect 1 value to be returned.

For the potential of multiple values being selected use
=Join(Parameters!YourParameterNameHere.Value,”, ”)
using .Label instead of .Value can result in awkward spacing between selected variables. You can test it out with your data.

The reason why this happens is because Parameters are Arrays. So if you want a particular value from the array then you need the .Value(value position). For the Join it will work through the entire array so you don't want to limit it to a particular value. Note that Arrays start at 0 not 1.

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
Employee
Employee

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors