Even though there are 50 Brands in the list, when hovering over a point on the view, you are doing just that--hovering over one point. Therefore, it is only returning the data for the one point, not all 50 (even if they seem to be in the same location)--meaning only one member of the 50 Brand members.
If this still does not seem to be the case, would you be able to post a screen shot and/or twbx file so that I can better understand the issue?
I think you're misunderstanding my question. The amount of text that I'm entering in the tooltip is being limited. When I go to Worksheet -> Tooltip, I run into a limit when adding more and more text.
It's make sense if you just kept entering characters until you reached the limit. For example, hold the "z" key down until it hits the limit.
I'm have the same want and having similar issue. The best I can determine is that the Tool Tip is limited by size or number of line items. I've tried using Left functions on a large text string to test various length but wasn't successful.
To crate a custom ToolTip, a 'Custom Calculated Field' was created using 'Char(13)' as the next line character. Currently, the most data I've insereted is 10 line items. Example Below.
"Region: " + [Region]
+ "Market: " + [Market Name]
+ "State: " + [State]
I'm going to play with embedding the ToolTip Text string in my Data Source as a new field. Maybe the limit is with the 'Custom Calculated Field' feature.
Please let me know if you have found a better solution, Thanks
Data cells have a limit of 255 characters (for example, one of my worksheets has reference/source information written out). It seems logical that the tool tips would have the same limit.
Andy, following your instruction I repeated 'z' until I hit the limit, and then pasted the results in Word to get the character count:
Results: 2,048. This includes line-break characters (if any). I confirmed this by trying to add a line break to the tool tip, it wouldn't let me. But when I deleted three of the 'z's I was able to add three line breaks before getting the error sound FX.
This is good to know. Thanks,
I'm having the exact same limit. Customized tooltips are really helpful when you want to show some additional YTD & YoY measures, Ratios, etc. Is there any chance that limitation will dissapear in the future?