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. 
AuraCorp's avatar
AuraCorp
New Member
10 years ago

So how could we show the difference between two figures? 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

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.

  • AuraCorp's avatar
    AuraCorp
    New Member
    10 years ago

    Yes of course.

    I am trying to migrate an existing excel dashboard to power BI.

     

    In this dashboard we show the current score and compare then to the previous score. We do not show the previous score but use a formula to compare them.

     

    The formula we use results in either a p or a q. I then use wingdings 3 to convert the p’s and q’s into up and down arrows and then use conditional formatting to make the font red or green.

     

    The other solution we have is to use VBA showing an up arrow and hiding the down or vice a versa based on a formula.

     

    I know arrows our a little old hat but my clients like them

     

    Thanks in advance.

     

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      10 years ago

      AuraCorp - OK, here is what I did, see if something like this will work for you:

       

      Values Table

      Value 1,Value2

      100,10

      20,5

       

      Keys Table

      Key,Image

      p,https://upload.wikimedia.org/wikipedia/commons/3/31/Urban_Meyer_vs_Michigan%2C_2013.jpg

      q,https://upload.wikimedia.org/wikipedia/commons/b/b5/Luke_Fickell_in_2014.jpg

       

      Formated Image as Image URL

       

      In Values, create new custom column:

       

      Key = IF([Value 1]-[Value 2]<20,"q","p")

       

      Relate Key to Key table

       

      Simple table visualization shown below:

       

       

       

      "p" is Urban Meyer, "q" is Luke Fickell

       

      So, if you have a red down arrow or green up arrow that you can point to online this might fit the bill.

      • Alexander24's avatar
        Alexander24
        Icon for Helper II rankHelper II
        10 years ago

        Hi 

         

        How did you format the image url? I get just a link when i do it?

         

        Thanks

        Alexander

    • greggyb's avatar
      greggyb
      Icon for Resident Rockstar rankResident Rockstar
      10 years ago

      Measures can return text values, and Power BI supports Unicode encoding by default, so you can certainly use character glyphs to get arrows in a textual measure. Unfortunately, we have no conditional formatting in PBI tables or matrices yet. You can get arrows based on the result of a measure, but not color.

       

      You can embed image URLs in a Power BI model as field values in a table. Unfortunately, you cannot return an image from a measure evaluation, so this seems like a dead end. I think what Greg_Deckler was saying was to have a second table aligned next to the KPI value. This table would display the image, and you can add an additional field to the visual-level filter for that table on the result of the KPI value, to filter that table to the appropriate image.

       

      You can vote for conditional formatting here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9422493-conditional-formatting-in-tables