Forum Discussion
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.
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.
4 Replies
- ankitpatiraCommunity 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.