I am already aware of how to do this, but the problem I am facing is that I want to apply the KPI to only specific rows in my table. The tutorial you posted applies the one KPI to the entire table. I am wondering if there is a workaround that will let me apply a KPI to only a certain row in the table, or a certain Measure Value.
2 of 2 people found this helpful
One option is to put the measures you want to color on a separate sheet, with the pill arrangement remaining the same (duplicate the original sheet, then change what measures are being displayed via your measure names filter), but only showing headers in the original sheet. Here is an example created using the Superstore data set. There are limitations to this--for example, if users want to export to Excel (crosstab), they'll have to export each sheet individually. Also, it can be difficult to get all the sheets to line up properly--I've used a horizontal layout container, with each sheet set to "Fit to Width" so they "look like" one sheet on the dashboard to the average user.
Again, I started with one sheet, filtered to Order Quantity only. Then, I duplicated the sheet twice, once to show Sales and again for Profit, with the same layout. Then, I hid the headers I did not want displayed again in each sheet--when placed on a dashboard (inside a horizontal layout container), we can create a view like this:
Version 8.1 workbook attached.
For more information on how Conditional Formatting can be applied in Tableau, I'd start here (there's a lot of content, but its worth studying): http://drawingwithnumbers.artisart.org/tag/conditional-formatting/
And his accompanying workbook: Introduction
Sorry about that.
Yes I had considered that, but having that kind of formatting means that it will mess up in any different aspect ratio when the dashboard fits to another screen. (I tried) I will try and check out the links you posted too but if there are any other suggestions for this I would appreciate it.