Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
dmartiprev
Frequent Visitor

KPI Color

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:

 

DateDaily Price of OilOil 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 DateLast 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?

0 REPLIES 0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.