Forum Discussion

dmartiprev's avatar
dmartiprev
Frequent Visitor
3 years ago

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 and red if the daily pric...
Need Help
  • dmartiprev's avatar
    dmartiprev
    Frequent Visitor
    3 years ago

    Hi Anonymous ,

     

    Really all I want to do is have a KPI that shows the "Daily Price of Oil" and will be red or green if the last "Oil Daily Price Change" was down or up from the previous day's price.  How do i do that?  I have three columns of data: "Date", "Daily Price of Oil", and "Oil Daily Price Change"

    • dmartiprev's avatar
      dmartiprev
      Frequent Visitor
      3 years ago

      Here is a visual of the KPI,  the color should be red since the daily change is negative.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi dmartiprev,

        Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

        How to Get Your Question Answered Quickly  

        Regards,

        Xiaoxin Sheng