Forum Discussion
Helper IIchange the Title text with input parameters
Hi,
I am using a Power BI template to work on my graphs. I accept user inputs (Parameterized variables) and one of them is the Product version. So based on the version my graph changes but the Graph Title shows the old/previous saved version only. I want the Version which I input, to reflect on the Graph Title as well. Is it possible to do so and if so how?
Thanks
Sudhir
Hi sprasad,
In Format tab, Turn off Category Labels.
Prateek Raina
PS: Please mark my post as solution if you think i have solved your problem. Also, don't forget to give a Thumbs Up :)
10 Replies
- BhaveshPatel
Super User
Hi Sudhir,
Check out the below blog post from Chris Webb.
https://blog.crossjoin.co.uk/2016/04/25/dynamic-chart-titles-in-power-bi/
You can also use the TOPN and VALUES combination or SELECTEDVALUE function.
Hope thos can help you out to solve the specific use case.
Thanks,
Bhavesh Patel
- prateekraina
Memorable Member
Hi sprasad,
Follow below steps to achieve what you need:
1. Go to Query Editor and enable load for the Parameter.
2. Load the data into Power BI model and use the parameter in your Title measure:
3. Export to Power BI template file.Now, whoever opens the template and fills in version number, the same will be reflected in the title.
Here is the link to the dummy template I created in case you need to replicate.Cheers !!
Prateek Raina
sprasadVersion as in Title TextI want this version to change to IE01.02
So that in the Graph it also changes when the user want to Input the Value as IE01.02
- prateekraina
Hi sprasad,
Changing the native title text is not possible dynamically.
The only workaround is that you should turn this off and use the card visual or any other similar visual as title for the graph.
Place it on top of Chart such that it looks as if it is the native title of the chart.
Prateek Raina
- sprasad
Hi Prateek,
I am not able to access the link to the dummy template. In the capture1.png, I see that Dynamic Title is a Measure field & Version/Version is what control? Littel bit confused.
How and where do I pass the Input value? Any help is appreciated
Thanks
Sudhir
- prateekraina
Hi sprasad,
Whats the error when you try to open the link?
When you click on Enable Load for parameter in Query Editor, it brings the parameter in form of table in Data view.That Version/Version which you see is actually the paarmeter name i.e. Version.
You can pass the input value by clicking on Edit Queries dropdown > Edit Parameter.
Prateek Raina
