Arrow up and Down

[AllanBerces]

Hi good day can anyone assist me, is it possible to add the up and down arrow inside % actual column instead of a new column like what i have. 

thank you

[sroy_16]

Hello,

You can directly add conditional fomratting on your existing table/matrix visual with the below steps.

• Apply Conditional Formatting:

  • Click on the table visual to select it.
  • Go to the Format pane (paint roller icon).
  • Expand the Conditional Formatting section.
  • Choose the column where you want to apply the formatting.
  • Select Icons (you can also use Data bars , but Icons are more suited for up/down arrows).

• Configure Icon Formatting:

  • In the Icons dialog box, choose to format by Rules.
  • Set up the rules to display icons based on the values in the column:
    • For Up Arrow: Set a rule for when the percentage change or value is greater than or equal to a certain threshold.
    • For Down Arrow: Set a rule for when the percentage change or value is less than a certain threshold.
  • You can customize the appearance by selecting the icons you want to use (up and down arrows) and defining their conditions.

• Customize Icons:

  • You can customize the icons and their colors under the Icon settings. Choose appropriate icons that match your report's design and color scheme.

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

[bhanu_gautam]

@AllanBerces , You can use DAX for this

 % Actual with Arrow =

   [% Actual] & " " &

   IF(

       [% Actual] > 0,

       "▲",

       IF(

           [% Actual] < 0,

           "▼",

           ""

       )

   )

Go through below video for details https://www.youtube.com/watch?v=9c3Pgxx5LyU

[AllanBerces]

Hi @bhanu_gautam thank you for your reply, when i try your solution it shows like

is it possilble to change if in percentage, and change the color to red if down and greeen if up together with the value.

Thank you

[Anonymous · Accepted solution]

Hi @AllanBerces ,

I create a table as you mentioned.

Then I create a measure as bhanu_gautam said.

% Actual with Arrow =
MAX ( 'Table'[%_Actual] ) & " "
    & IF (
        MAX ( 'Table'[%_Actual] ) > 0.7,
        "▲",
        IF ( MAX ( 'Table'[%_Actual] ) < 0.7, "▼", "" )
    )

I create another measure and here is the DAX code.

Measure = IF(RIGHT([% Actual with Arrow],1)="▼","Red","Green")

Then I choose Conditional formatting and go to Font color.

Finally you will get what you want.

Best Regards

Yilong Zhou

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

[AllanBerces]

H @Anonymous @bhanu_gautam @sroy_16 thank you for your support. working fine now.

[AllanBerces]

Hi @Anonymous can i know what is the 0.7 on the measure you created.

Basically what i required is if the % Actual is higher the % Daily then Green value and up arrow, if below then Red value and down arrow.

Thank you

[bhanu_gautam]

Go thorugh the video link which I have shaared it has similar scenario with color