Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Proud to be a Super User!
Solved! Go to Solution.
You may try adding CONVERT.
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
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
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,
Hi,
What is the datatype for the measure?
I belive measures used for titles must must be a string datatype for it to work
The measure is a string that shows a range of dates with this format: dd/mm/yy - dd/mm/yy.
Proud to be a Super User!
Could you post the entire measure?
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
Proud to be a Super User!
You may try adding CONVERT.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |