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

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Reply
akamiller
New Member

Display Query Parameter Values as a Label on a Report

I know you can't yet interact with the parameters on a report, but how I can display the value of a parameter as a label at the top of a report?

 

I'm going to save my report as a template.  I then want to enter my two parameter values when I use the template (start date and end date).  My queries will run using these parameters and I want to display the value of those parameters at the top of the report.  Is this possible?  I can't seem to find anything here in the forum.

1 ACCEPTED SOLUTION
ankitpatira
Community Champion
Community Champion

@akamiller in power bi desktop under query editor right click your parameters and click Enable Load. Close & Apply and that will make your parameters visible in reports. Then depending on the parameter type if number then you can use KPI visual or if text then download custom visual called Long Text Viewer and use that to drag and drop parameters onto report.

 

Capture.PNG

View solution in original post

4 REPLIES 4
ankitpatira
Community Champion
Community Champion

@akamiller in power bi desktop under query editor right click your parameters and click Enable Load. Close & Apply and that will make your parameters visible in reports. Then depending on the parameter type if number then you can use KPI visual or if text then download custom visual called Long Text Viewer and use that to drag and drop parameters onto report.

 

Capture.PNG

Can't seem to find the Long Text Viewer visual, any alternatives?

Search it in google and then download it. You wont find it in visual market in power bi desktop, but u have to upload it as a file

Long Text Viewer - exactly what I needed!  Thanks!

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.