Forum Discussion
Post PatronHow to bring parameter values to Power bi visual?
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
Here is the solution steps I followed:
1. Create StartDate and EndDate parameters2. 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
3 Replies
- amitchandak
Super User
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/
pthapaThank 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
Here is the solution steps I followed:
1. Create StartDate and EndDate parameters2. 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
