Forum Discussion
danextian
Super User
6 years agoCannot select a measure as a visual title
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.
Gordonlilj
Solution Sage
6 years agoHi,
What is the datatype for the measure?
I belive measures used for titles must must be a string datatype for it to work
danextian
Super User
6 years agoThe measure is a string that shows a range of dates with this format: dd/mm/yy - dd/mm/yy.
- Gordonlilj6 years ago
Solution Sage
Could you post the entire measure?
- danextian6 years ago
Super User
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-msft6 years ago
Community Support
You may try adding CONVERT.