Cannot select a measure as a visual title

[danextian]

Hello,

I don't know what I am missing. I can't select a measure as a dynamic title of a visual. The measures are in the dropdown but can' be selected.  

[chahineatallah]

I am having the same issue, am not able to select my measure to be used as title

my measure gives a text ,tried also the convert but still no chance to work

Title = var st= IF(HASONEVALUE('date'[Year]),

IF(HASONEVALUE('date'[Month Name]),

"",

AVERAGEX(VALUES('date'[Month Name]),

"Average workouts per month")))

return

CONVERT(st,STRING)

[molegris]

Hi,

Just for those who are still struggling despite the advise to use CONVERT.  You might have done the same mistake I did.  CONVERT is not going to work alone... you need to change the type on the settings of the measure.  duh!  can't beleive I missed it!

Actually, after changing the type in the settings part, I didn't even need to use the CONVERT function.

regards,

--mo

[jochenj]

i have the same issue: measure is visible but not selectable in the dialog of Title Expression 

Tried with simplest possible measure without success:
lblX = "My Custom Title"

The only thing i can choose in this "Title Text" dialog are COLUMNS but not MEASURES 

Any hints? 

Thanks,

[Gordonlilj]

Hi,

What is the datatype for the measure?

I belive measures used for titles must must be a string datatype for it to work

[danextian]

The measure is a string that shows a range of dates with this format: dd/mm/yy - dd/mm/yy.

[Gordonlilj]

Could you post the entire measure?

[danextian]

I'm posting a different measure since the period range measure is dependent on othe pretty long measures. This one is pretty simple but still I can't select this as a visual title.

P&L Overview text =
VAR __RANGE =
    SELECTEDVALUE ( 'Actual vs Benchmark Measures'[Range] )
VAR __BENCHMARK =
    SELECTEDVALUE ( 'Actual vs Benchmark Measures'[Benchmark] )
RETURN
    "P&L Overview " & __RANGE & " " & __BENCHMARK

[v-chuncz-msft · Accepted solution]

@danextian 

You may try adding CONVERT.

https://community.powerbi.com/t5/Desktop/expression-that-yield-variant-data-type-cannot-be-used-to-d...