I'm not sure if this is possible, but I agree it would help.  You should be able to select a header like "CAD" and get summary information for the bar once it is selected.  I know its not what you want, but it may be the only option.  Other forum members may know more--I am not an expert.

You might try a small hack, which is to add another invisible mark on a dual axis.

For example, in the below, I created a calculated field Tooltip Select =

IF [Gross Profit Ratio] < 0

    THEN WINDOW_MIN([Gross Profit Ratio])

    ELSE WINDOW_MAX([Gross Profit Ratio])

END

Then I added this to the view and used dual measure. In the marks window for Tool Tip Select, I select color > transparency = 0%.

You can remove this field from the tool tip, but whenever you "land" on the invisible area, the tooltip will show with, in my example, the Gross Profit Ratio.

See attached.

Jim

Nice trick to extend the tooltip information to the end of the longest positive/negative bar.

Jorge,

If you don't mind the width of your bar label being the same width as your bar chart, then look at the "Using Index" tab of the attached workbook (which came from Jim Wahl's earlier example). Here I take advantage of the dual axis feature, calculated fields with the Index function, shapes that are white with sizes that are too small to be noticeable, a fixed table axis, and reformatting the axis font colors so they too are white -- if white is not your background color, set the color accordingly.

Hope this helps,

Andy

I like it!

Do you need to use INDEX() or can you just set it to 1, add the measure as a MIN aggregation type, and then set the axis to go from 0 to 100?

Jim,

I'm sure you can use another formula besides index. Because the location where the text (label in our case) displays is the location of the mark on the chart, I needed a way to make the number really small (so I used Index *.001) and then set a fixed axis much larger. This gives the impression that the text (label) for each bar starts left justified, when in fact none of the text is lined up with the text from any other row.

Andy