-
1. Re: Conditional Formatting for multiple Measures
Joe OppeltJan 19, 2018 9:08 AM (in response to Marissa Sarlls)
There is a trick that lets you do this, but it's hard to describe. Can you post a sample workbook so I can show you?
Essentially you put SUM(0) in your columns shelf, as many times as you have measures you want to display. Then you put the individual measures on the TEXT shelf for each individual mark type, and you can color each one by different criteria.
-
2. Re: Conditional Formatting for multiple Measures
Marissa Sarlls Jan 20, 2018 7:09 AM (in response to Joe Oppelt)Yes, I posted a sample workbook.
-
3. Re: Conditional Formatting for multiple Measures
Joe OppeltJan 20, 2018 2:17 PM (in response to Marissa Sarlls)
(10.4 here)
In the attached I did two of your measures. You can model the rest in the same way.
To get more SUM(0) pills in the COLUMNS shelf, just double click in the empty part of the COLUMNS shelf, and you will get a little edit box. Just type in 0 and hit return. Now you have a new mark. For that mark, drag SUM(next_measure) onto TEXT. Hack up a new Color calc, and drag that onto COLORS. Then click in the axis that just says 0 and EDIT AXIS. Change the name of the axis to whatever you want. Then click the tab that says "Tick Marks" and change the tick marks to NONE. (Minor ticks really won't matter here, but I turned them off too.)
You can see that I picked different colors and fonts in this sheet. You probably aren't going to want that, but I did that to demonstrate how you can format each measure however you want.
See attached.
-
Tableau Demo_v10.4.twbx 52.0 KB
-