change the Title text with input parameters

[sprasad]

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

[prateekraina]

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

[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

[sprasad]

Hi Prateek

I had already created the parameters but I missed checking the Enable Load option.  I think now it should work. I will let you kow.

Thanks

Sudhir

[sprasad]

HI Prateek

Its working . Thanks for your help and suggestion.

One more question - How to remove the "Dynamic Title" text in the card?

Thanks

Sudhir

[prateekraina · Accepted solution]

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 🙂

[sprasad]

Thanks Prateek. It worked. Al it was a good learning for me.

[sprasad]

Version 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

[BhaveshPatel]

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