I've attached a revised copy of your workbook. I used the steps outlined in this KB to apply the different color thresholds to each individual row:
Hope this helps
Sample_REVISED.twbx 48.3 KB
Thank you so much! I just having problems showing the headers for each row. It's displaying as "number of records" instead of NPS, Utilization, etc....
also, do you know of a way to rotate the headers so they read across as oppose to up and down?
Is there a way to move the fiscal months from the bottom to the top?
Sadly using this workaround forces us to only be able to have the labels vertical since it requires creating an axis (continuous field). The way Tableau works is that we get a separate Marks card for each axis. Having separate Marks cards allows us to apply different KPI formulas to each measure, but the one drawback is that we have to stick with vertical labels for the axis.
For the other questions though, we can accomplish this with some creative use of formatting and duplicate fields
To change the axis labels we just need to right-click on an axis and then select the Edit Axis option:
From here you can set the title to be whatever you like:
To move the fiscal month labels up to the top we'll need to first create a duplicate of Fiscal Month by right-clicking it in the data pane and selecting Duplicate:
Next, you'll need to drag the duplicate field onto Columns to the right of the first Fiscal Month field. Then right-click the duplicate field and deselect the Show Header menu option. Voila! The labels are now at the top