Conditional Performance Indicators in Tables using HTML Unicode Chr() Values
Inserting KPI indicators into tables is actually quite simple if you understand the HTML Unicode UTF-8 characters that are available for you to use and display with simple if conditions. These characters behave like any other text so applying conditional colors is very simple.
Some examples, an example application and a link to many character options are at the bottom of this post.
Setting up the Measure
The measure needs to be a simple if statement, for example:
if([Sales This Year]>[Sales Last Year],chr(9650),chr(9660))
Where 9650 and 9660 are the triangle up and down character codes based on standard HTML Unicode UTF-8 charsets.
Setting up the conditional colours
Under Text color Expression use an if statement to switch the colours similar to the measure expression, for example:
if([Sales This Year]>[Sales Last Year],rgb(0,220,0),rgb(255,0,0))
I have used the field names of the columns in the table to create these expressions rather than repeat the measure expression by wrapping the field label in square brackets (as you will most likely know as of version 3.2 we can not reference the Master Items here). For this method to work both fields must be visible in the table.