I have made this before but now it doesn't seem to work correctly. I made a KPI tile of daily crude oil prices that i want to be green if the daily price change is positive (i.e. price is higher than yesterday) and red if the daily price change is negative (i.e. price is lower than yesterday). I have three columns of data in "Table1": Date, Daily Price of Oil, and Oil Daily Price Change which is how much the price of oil has gone up or down since the previous day. Here is a sample of the data in this table:
| Date | Daily Price of Oil | Oil Daily Price Change |
| 8/23/2021 | 65.65 | 3.40 |
| 8/24/2021 | 67.50 | 1.85 |
| 8/25/2021 | 68.54 | 1.04 |
| 8/26/2021 | 67.42 | -1.12 |
| 8/27/2021 | 68.84 | 1.42 |
| 8/30/2021 | 69.28 | 0.44 |
| 8/31/2021 | 68.43 | -0.85 |
I have also created a second table "Last" that only has two columns with one row in them: "Last Date" and "Last Change" and in the single row below them is data for the last date of the dataset of the first table and the last datapoint of the daily change in dataset of the first table. For example this Table would contain this data.
| Last Date | Last Change |
| 8/31/2021 | -0.85 |
I set the Values of the KPI tile to be the column of data for the "Daily Price of Oil" in Table1 and the target for the KPI to be "Last Change" from the table "Last". Therefore, in the trend axis I set a rule for coloring if the "Last Change" is >0 then green and if <0 then red and yellow if = 0. However, this doens't seem to work. any ideas what I'm doing wrong?
