2 of 2 people found this helpful
This is an old post and if you (or anyone else) is interested in this, it is very possible to do exactly what you are after using calcs dropped to the level of detail shelf.
I recommend reading Andy's post http://interworks.co.uk/andy-cotgreave/tableau-tooltips-conditional-formatting/
This link is broken, btw.
I'm not surprised, this is a very old post and Andy has been with Tableau since 2011.
Essentially, it is possible to create a conditional tooltip in the same way that it is possible to add bar charts to them: by creating different calculations that match-up to your data-set.
A quick example of which:
- Open superstore sales
- Drop sub-category to the rows
- Drop profit to the data
- Create a calculation: [Negative Profit] If Sum(Profit) <0 Then Sum(Profit) End
- Create another calculation: [Positive Profit] If Sum(Profit) >=0 Then Sum(Profit) End
- Drag your two calculated fields to the detail tab and
- Edit the tool-tip to read: Profit: <AGG(Positive Profit)><AGG(Negative Profit)>
- Colour the positive profit calculation part of the tool-tip to green and the negative part to red
- Press ok and now hover over positive and negative calculations in your chart - hey presto, tool-tip conditional formating