cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
akamiller Frequent Visitor
Frequent Visitor

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

Accepted Solutions
ankitpatira Super Contributor
Super Contributor

Re: Display Query Parameter Values as a Label on a Report

@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 Super Contributor
Super Contributor

Re: Display Query Parameter Values as a Label on a Report

@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

akamiller Frequent Visitor
Frequent Visitor

Re: Display Query Parameter Values as a Label on a Report

Long Text Viewer - exactly what I needed!  Thanks!

Highlighted
ikkew Regular Visitor
Regular Visitor

Re: Display Query Parameter Values as a Label on a Report

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

vitaly_p Occasional Visitor
Occasional Visitor

Re: Display Query Parameter Values as a Label on a Report

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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors