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.