-
1. Re: Different Color Labels on Line Graph
pooja.gandhi Mar 16, 2016 12:38 PM (in response to Meagan Marroquin)1 of 1 people found this helpfulMeagan!
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)
-
2. Re: Different Color Labels on Line Graph
Nicholas HaraMar 16, 2016 12:40 PM (in response to Meagan Marroquin)
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.
-
coloringText.twbx 1.2 MB
-
-
3. Re: Different Color Labels on Line Graph
Meagan Marroquin Mar 16, 2016 1:16 PM (in response to Meagan Marroquin)1 of 1 people found this helpfulThank 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.
-
4. Re: Different Color Labels on Line Graph
Nicholas HaraMar 16, 2016 1:25 PM (in response to Meagan Marroquin)
1 of 1 people found this helpfulHi 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.
-
5. Re: Different Color Labels on Line Graph
Meagan Marroquin Mar 16, 2016 1:32 PM (in response to Nicholas Hara)I got it now! Thank you Nicholas