This content has been marked as final. Show 1 reply
Hi. I originally had these three rows (see screenshot below) combined into one row. However, I was requested to conditionally format each column based on it's percentage (so irrespective of what value is in the other columns). For example, I wanted anything below 1.0 (i.e., 100%) to be some shade of red and anything above 1.0 to be some shade of green. Another layer of complexity to this is that there are 2 other sets (for a total of 3 sets) of this visual based on the Forecast Category filter. So there is technically a whopping 36 values in the data source, where 12 are displayed at once. What I noticed is that when I start combining these rows into one row, the "Multiple Fields" in the Marks section on the left-hand side will ultimately turn into one measure, which is not what I want. I don't want it to be "SUM(Factor)" in the Color mark to affect the "Manager" columns in the visual... Hope that this makes sense. So how do I display conditional colors for each of the columns that are placed together in one row?
Here's a sample of how the data source looks like:
|Team 1||Best Case||1.02||2.33||1.11|
|Team 2||Best Case||0.33||0.55||1.22|
|Team 3||Best Case||...||...||...|