How to bring parameter values to Power bi visual?

[pthapa]

Hello All,

I was wondering if there is a way or workaround to bring the parameter values being selected in power bi report to show in power bi visuals.

Example scenario; I have a report that has Start and End date parameters from a Stored procedure. When user enters the start and end dates as parameter value, the report will update. I want to bring these entered values from parameters to show in visuals so report viewer knows what date range was selected. 

Is there a way possible to bring the parameter values in the visuals? Please provide some insight.

Appreciate your time!

Thanks,

Keep Learning PBI.

Pthapa

[pthapa]

Thank you amitchandak for sharing the post, this will obviously help me in my future projects. However, I found the solution to my question.

Appreciate your time.

Pthapa

[pthapa · Accepted solution]

Here is the solution steps I followed:
1. Create StartDate and EndDate parameters

2. Enable these two parameters to load.

3. Those two parameters will show as table now in data model.

4. Create a measure based on those Parameters to show them in the visuals as needed.

Hope this helps for those who are willing to get the solution to this.

Keep learning PBI.

Pthapa

[amitchandak]

@pthapa , I think Dynamic M parameters can help

https://blog.crossjoin.co.uk/2020/10/25/why-im-excited-about-dynamic-m-parameters-in-power-bi/