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?
Solved! Go to Solution.
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.
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
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.
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.
Its working . Thanks for your help and suggestion.
One more question - How to remove the "Dynamic Title" text in the card?
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.
Check out the below blog post from Chris Webb.
You can also use the TOPN and VALUES combination or SELECTEDVALUE function.
Hope thos can help you out to solve the specific use case.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.