2 of 2 people found this helpful
18 months ago I created and idea for having modifiable reference line tooltip and in this period no one has suggested any workaround. Therefore I think the answer is that no workaround is available.
You can up-vote mentioned idea and thus influence Tableau to make improvements in this regard.
Thanks for pointing out your Idea, Kettan. I upvoted it.
One workaround would be to create a aggregated calculated field of the field you want to use and title it whatever you'd want to show up after the calculation.
For example, we had a field for an average likert score that was showing up as "Average Avg. National Average = ___", which I was able create and aggregated field (=AVG([National Average])) and name it "Network Likert" so the tooltip now shows as "Average National Likert = ___" which is much more readable! It's not perfect but it's better than the default.
2 of 3 people found this helpful
Just figured it out today.
Right click your reference line and hit format.
Click the Dates drop-down, scroll down to Custom and write your text in "quotation marks". Your text will remain and the quotation marks will not. When you hover over your reference line, it'll act just like a well laid out tool-tip.
Matt Sikora almost had it.
I performed the following:
- Right-click on the reference line and choose format
- Under the "alignment" section click on the dropdown option and choose "Custom"
- From here, type in the text you want to appear in quotes followed, or preceded by, the format for the value.
Note: my original change was done a little different. After step 1 I first chose the number format I wanted the value to come back as. This helped populate the custom box with the formatting before the desired text was entered. Try this and then continue with step 3 if the first method gives you trouble.
This is quite helpful info -- thanks for sharing, all.