Dynamic title name doesn't change

[Christianvs]

Hi 

I have a chart to which I would like to add a dynamic title. I created a measure to make the text for the dynamic title and it seems to work on a Card, but not when used for a chart title.

The dynamic part is the name of a user (X): "Antal sager løst af X fordelt på". When I choose a name in the table to the right of the chart, the text changes in the Card in the bottom but it doesn't change the title text.

Can anyone help me here?

Thanks

[v-fenling-msft]

Hi, @Christianvs 

May I ask if you have gotten this issue resolved? If it is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

If it is not resolved, I hope you will provide the full .pbix file via OneDrive or SharePoint. Please be careful to remove all sensitive information and we will do our best to provide ideas for your issue.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Christianvs]

Hi @v-fenling-msft 

There havent been any suggestions to do anything different than I already does, so I'm afraid not.

I have a working measure that works correctly when I use it as conditional formatting in a card or a text box, but won't work when I use it as conditional formatting for the bar chart.

I'm afraid I wont be able to upload the .pbix file

[DataNinja777]

Hi @Christianvs ,

To add a dynamic title to a chart in Power BI, you need to create a measure that generates the desired text dynamically based on user interaction, and then use that measure to conditionally format the chart title. You mentioned that the dynamic text works on a Card visual but doesn't update when used as a chart title. This typically happens because the chart title needs to be explicitly linked to a field value for the dynamic text to work.

First, ensure you have a DAX measure that constructs the title based on the selected user. Here's an example of a measure that achieves this:

Dynamic Title = "Antal sager løst af " & SELECTEDVALUE('Users'[UserName]) & " fordelt på"

In this measure, SELECTEDVALUE is used to dynamically retrieve the name of the user selected from a slicer or table. The text string "Antal sager løst af " will change depending on the user's selection.

Once your measure is created, you need to apply it to the chart's title. To do this, select the chart in your report, go to the Visualizations pane, and under the Format Your Visual section, find the Title option. Next to the Title Text field, click the small fx button to open the conditional formatting window. In the conditional formatting settings, choose Field value as the formatting option and select your Dynamic Title measure from the dropdown. Click OK to apply the dynamic title.

This approach should resolve the issue where the title works in a Card visual but doesn't update dynamically in the chart title. The key step is setting the title text to be conditionally formatted by a measure, as Power BI does not automatically apply dynamic titles to charts without this configuration.

Best regards,

[Christianvs]

Hi @DataNinja777 

I posted my issue a bit too fast and forgot to add that the measure I use is as you write it:

And I already added it as a conditional formatted text:

It is in danish in my screendumps, but it should be possible to decipher whether I've done it correctly

[danextian]

Are you using the same column from the image below in your measure?

If you're using the same column, this should return a single value when one is selected otherwise it will be "alle burgere" as in your measure. If you're not using the same column, there could be more than one value  of  navnpabruger for each x1 value and if there are more than one values, SELECTEDVALUE will return the alternate result.

[Christianvs]

Hi @danextian 

Just to clerify, the columns in the image are anonymized. I added a white box with X1, X2 and so forth.

The actual table/column only returns one value as far as I am aware. And it works if I use the measure in a text box or a card, then the text displays the name of the selected user correctly. But if I select multiple values it returns "alle brugere".

So it seems that the measure that created the dynamic text works perfectly fine when I use it in a text box or a card, but not when I use it as a conditionally formatted title.

Did that answer your question?