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

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

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

        Hi Thanks Ruth! I actually managed to do it both ways via your way and also through linking an image to them with different colours,

         

        Luckily we can now import KPI's from SSAS and PowerPivot to make things a bit easier!!

         

         

    • rajasuman09's avatar
      rajasuman09
      New Member
      9 years ago

      Go to Modelling tab and select the table column in which URL is present. On the top there is a 'Data Category' dropdown. Select Image URL in it. You should see images when you return to report.

       

      Thanks,

      Raja

    • 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

  • VidaLi's avatar
    VidaLi
    Frequent Visitor
    9 years ago

    HI, Greg_Deckler

     

    how did you manage to get your picture URL display as image.

     

    I used matrix to create a table. but when use the image URL as VALUES, it's still dispaying as URL not the actual image, i have applied the set the column to be "Image URL" as for the Data Category.

     

    I read from other post where it will work for ROWS but not values, i have tried that it's the fact for me. can you please let me know how did you make the image to display and it's a value of the table please?

     

    thanks,

    Vida

  • VidaLi's avatar
    VidaLi
    Frequent Visitor
    9 years ago

    HI, Greg_Deckler

     

    how did you manage to get your picture URL display as image.

     

    I used matrix to create a table. but when use the image URL as VALUES, it's still dispaying as URL not the actual image, i have applied the set the column to be "Image URL" as for the Data Category.

     

    I read from other post where it will work for ROWS but not values, i have tried that it's the fact for me. can you please let me know how did you make the image to display and it's a value of the table please?

     

    thanks,

    Vida

    • VidaLi's avatar
      VidaLi
      Frequent Visitor
      8 years ago

      instead of Matrix, you have to use use tables to be able to display the image. Matrix doesn't work. 

       

      Thanks,

      Vida