Dynamic title based on the highest value of the graph

[BaronSdG]

Hi all,

I have the following graph which changes depending on the time period selected.

The column 2 is the sum for each category in column 1.

I want only the text from column 1 in a custom title e.g. "Graph with all values except" & 'xxx'. 

How to derive the first row text from column 1?

[v-deddai1-msft · Accepted solution]

Hi @BaronSdG ,

You can create a measure for your title like:

Measure = "Graph with all values except" & [highest value]

And use it in conditional title:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai