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. 

24 Replies

  • 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

     

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    There currently is no ability to edit interactions with shape visualizations or, to my knowledge, any kind of "conditionality" that you can have on shape visuals.

     

    You could potentially get there with a custom column and a related table. What I am thinking of would be a table with your shapes loaded as images (URLs) along with something like an associated number or something, 1, 2, 3. You could have a custom column that based upon the comparison of two numbers, resulted in 1, 2, 3. IF([comparison]>xx,1,2) something like that. Then place the image in a table or card and filter it based upon the item selected. Obviously, I don't know anything about your data and this potential solution would only work in specific circumstances.

    • AuraCorp's avatar
      AuraCorp
      New Member

      So how could we show the difference between two figures? 

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion

        AuraCorp - Can you provide a little more information on what you are trying to accomplish? I'm not following what you are trying to do.