Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to Create arrows showing increase and decrease of value

Hello people,   I wanted to ask for help with a thing I am stuck on.  Using arrows, I need to show in the last column if the value has either increased or decreased. When tried conditional formatti...
Show and Tell
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi Anonymous ,

     

    Based on your description, I have created a simple sample:

    Please try:

    Measure2 = IF(SELECTEDVALUE('Table'[Prior Value])<SELECTEDVALUE('Table'[Current Value]),1,-1)

    Then apply it to the visual -> conditional formatting:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Anonymous ,

 

Based on your description, I have created a simple sample:

Please try:

Measure2 = IF(SELECTEDVALUE('Table'[Prior Value])<SELECTEDVALUE('Table'[Current Value]),1,-1)

Then apply it to the visual -> conditional formatting:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi There,

 

 Thanks for the solution, but not all rows are showing the right trends. 

Below is the conditional formatting condition used by me: 

 

I would appreciate it if you help me out with the right condition, been stuck here for past 3 days. 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    in order for your measure to work correctly you need clean data.  Neither "NA"  nor "BBB+"  are numbers.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi, would you suggest null value in place of NA? also BBB is the Bond rating.

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        3 years ago

        Use whatever data is appropriate in your scenario.  Don't mix numbers and text values.