up arrow / show a shape based on a formula

[AuraCorp]

Hi all. 

I just want to show a shap (in this case a green arrow) based on a comparision between two numbers. 

[ruthpozuelo]

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

[Anonymous]

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=eyJrIjoiNDk5MDhjMzYtOGMxMi00ZjM5LWEzNzktZTkwY2M0NzdmMDU4IiwidCI6IjY2N...

Regards

[pekkak]

ravsha85, can you share us your desktop file?

[belenquiroga]

Thanks, I think this is the right solution

[PHunosøe]

Hi

I have a problem finding the solution to this question.

Can anybody help ?

Kr / Per Hunosøe

[Greg_Deckler]

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]

So how could we show the difference between two figures? 

[Greg_Deckler]

@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]

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]

@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.

[VidaLi]

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]

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

Thanks,

Vida

[VidaLi]

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

[Alexander24]

Hi 

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

Thanks

Alexander

[PHunosøe]

Hi

I have a problem finding the solution to this question.

Can anybody help ?

Kr / Per Hunosøe

[rajasuman09]

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

[ruthpozuelo]

Hi Alexander,
It is not an image but a symbol within a DAX measure.
Maybe this helps:
https://youtu.be/7oCygwn75tQ
/Ruth

[Alexander24]

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!!

[ruthpozuelo]

Great! Glad it worked! I am still waiting for native KPIs in power bi...
Have a great evening 🙂
/Ruth

[Alexander24]

I Know right , also cant wait until they let you change the axis size as well xD My bosses profusley moan at me for not being able to make it readable to stick a snapshot in a slide!

Hopefully the basics will come eventually!

Have a good evening too