Forum Discussion

AuraCorp's avatar
AuraCorp
New Member
10 years ago

up arrow / show a shape based on a formula

Hi all.    I just want to show a shap (in this case a green arrow) based on a comparision between two numbers. 
ruthpozuelo's avatar
ruthpozuelo
Icon for Post Prodigy rankPost Prodigy
10 years ago

Hi,

 

You can also use Cambria Math symbols to display the arrows.

Using a similar example smoupre gave you, the formula would look like: 

 

Key = IF([Rank Trend]>-1,"⇧", "⇩")

 

 

You can copy the arrows directly from this thread into power bi.

/Ruth

 

  • belenquiroga's avatar
    belenquiroga
    Regular Visitor
    10 years ago

    Thanks, I think this is the right solution

    • PHunosøe's avatar
      PHunosøe
      Frequent Visitor
      8 years ago

      Hi

       

      I have a problem finding the solution to this question.

      Can anybody help ?

       

      Kr / Per Hunosøe

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi all,
    Thanks for your contribution to the Community , I am learning and enjoying it because of you guys.
    I have tried the KPI indicators using ruthpozuelo  method as well as smoupre, I was able to use Unicode symbols in both Table and Matrix , Since I needed coloured arrows I was working with Image url's also, But it was not working as expected for me in Matrix.

    Any workaround for this? I have shared a sample published link for your understanding.

     

    https://app.powerbi.com/view?r=eyJrIjoiNDk5MDhjMzYtOGMxMi00ZjM5LWEzNzktZTkwY2M0NzdmMDU4IiwidCI6IjY2NWI2YzYyLTczMTAtNGQzOS05YWJiLTMyYTBjYmMzYjkwZiIsImMiOjEwfQ%3D%3D

     

    Regards

     

    • pekkak's avatar
      pekkak
      Regular Visitor
      9 years ago

      ravsha85, can you share us your desktop file?