Is there anyway that I can have the labels and dots on the line above the Goal reference line a different color than the labels below the line? I would like the labels 60% or above to be green and the labels below 60% to be black. 
Meagan!
You can create a calc like:
if sum([Sales]) > 150000 then 'green' else 'red' end
Place this calc on color and use 'match mark color' setting on label (this is only available post version 9.2 though)
Mar 16, 2016 12:40 PM
Hi Meagan,
First you will need to create a KPI calculation.
Creating Key Progress Indicators (KPIs) | Tableau Software
Next, create a dual axis chart where the second graph type is Text. This will allow for individual formatting.
I have attached a sample workbook with three possible ways to approach the problem.
Thank you both for your help! This is my first time to ask a question in the forum.
Is there something wrong with my formula? It is only picking up black and not the green.
Mar 16, 2016 1:25 PM
Hi Meagan,
You are probably just calculating the table function incorrectly.
1. Right-click the calculation pill
2. Select Compute Using > Table (down)
Check out the Table Calculations help here: Understanding Table Calculations
Top 10 Tableau Table Calculations | Tableau Software
That should fix it, if not, a sample workbook will help us better understand the issue.