Simple Dynamic Chart Title

[Keith011]

Hello There!

I have been searching for the solution everywhere and the cases that I found is too complex. Well, mine is much more straightforward and simple but I just can't figure it out!

I have a survey Pie Chart and the data looks something like this: .. very simple

Now, I visualized it in power bi in a Pie Chart. I want the title of this pie chart to change dynamically base on which survey question i select. Like in this below screen shot, I'd want the chart title to change dynamically and be "The topics discussed in this meeting are relevant to my.......". and for the next survey, the chart title would change as well base on the question.

Everyone's solution is too complex whereby they are solving dynamic chart title base on slicer or filter etc... but mine is more simpler. No filter No slicer, just dynamically change chart title base on what i select in the legend element of the chart

[MFelix · Accepted solution]

Hi @Keith011 ,

Being your values in a table that each column is a question best option is to unpivot the values of the columns and then use the values of the table to filter the charts, then create a measure like:

Chart Name = SELECTEDVALUE(Table[Question])

Now use this has the name of the chart in the options.

Check an example below:

PBIX file attach.