10 Replies Latest reply on Jun 21, 2017 12:18 PM by Glenn Kuly

# How can I link supplemental tooltip data to specific measure names?

I have a line chart with multiple measures plotted on the same axis (various measures for annual data). The measures are all number values, but I would like to provide "percent of total" in the tooltip, unique to the specific measure hovered over.

The tooltip would be:

Measure Name

Measure Value

Measure Value as a Percent of Total (i.e. (Measure Value/Total)*100)

I cannot find a way to link the "percent of total" information to the tooltip for each specific measure. Does anyone know of a way to do this?

Thank you.

• ###### 1. Re: How can I link supplemental tooltip data to specific measure names?

Hi Claire, there are a couple way to do this, simplest is to drop a copy of the measure name onto the Tooltips shelf, and make it a Percent of Total table calculation, as shown below:

Another way is to use a calculated field as a tooltip, which is longer (I prefer this route because it's easier to dbl check results in a crosstab):

The (intermediate) total sum of sales calculation is: Sum Sales: TOTAL(SUM([Sales]))

The attached workbook has charts with both approaches.

-- Glenn

• ###### 2. Re: How can I link supplemental tooltip data to specific measure names?

Thank you Glenn, but that wasn't exactly my question.

I want to know how to do this when you have multiple measures on one axis. I'm attaching a workbook that's an update of the one you sent, but adding in a profit line to the graph. I calculated annual profit as a percent of total profit, just as you did with sales.

I want to have the Sales line tooltip show only the sales number and the sales percent, while the Profit line tooltip shows only the profit total and the profit percent. As is currently constructed, I can only get BOTH the sales and profit percents on each line. I want only the corresponding percentage in each line's tooltip.

• ###### 3. Re: How can I link supplemental tooltip data to specific measure names?

One more addition. I could imagine working around this by creating a Dual Axis if there are only two measures. But what about three or more measures?

• ###### 4. Re: How can I link supplemental tooltip data to specific measure names?

Hi Clare, I don't have 10.3 on my laptop yet, but I think I've recreated what you've done.

You can get the result you want by using the above technique on each separate marks card. I've dropped Sales (percent of total table calculation) into Tooltips on the Sales Marks Card, and Profit (percent of total table calculation) into Tooltips on the Profit Marks card.

Whatever you drag into Tooltips on the All card will show up in all tooltips, but if you set up Sales and Profit separately, you'll get tooltips specific to each measure.

-- Glenn

• ###### 5. Re: How can I link supplemental tooltip data to specific measure names?

Sure, so this works when there are two series. What if we have a third series in the graph, and the Dual Axis approach no longer works for this?

• ###### 6. Re: How can I link supplemental tooltip data to specific measure names?

Just saw your supplemental question, same answer as above. Set up tooltips separately for each measure on its own Marks card, rather than setting up tooltips on the All card.

If you post an example, I can walk you through the set up (i now have 10.3 for public, but only 10.2 for desktop).

-- Glenn

• ###### 7. Re: How can I link supplemental tooltip data to specific measure names?

Hmm, well when I add a third series onto the same axis, the series convert to measure values and don't have separate Marks cards.

• ###### 8. Re: How can I link supplemental tooltip data to specific measure names?

As long as your dragging measures separately onto the Rows shelf (as oppose to using Measure Names/Measure Values pills), you should be getting separate Marks cards for each measure.

Can you post an example?

-- Glenn

• ###### 9. Re: How can I link supplemental tooltip data to specific measure names?

Sure. I made up some data to illustrate.

I want to graph four series (product sales) on one axis, as shown in the attached workbook. My goal is to put the "percent" measures in the tooltips of the corresponding series, but not in the tooltips of the other series. It is essential that the measures are graphed on the same axis.

• ###### 10. Re: How can I link supplemental tooltip data to specific measure names?

I only have Desktop 10.2, and can't open your workbook. Can you put up screenshots?

-- Glenn