cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

New Member

## 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 24
Kudo Kingpin

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
Not applicable

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

Regular Visitor

ravsha85, can you share us your desktop file?

Regular Visitor

Thanks, I think this is the right solution

Frequent Visitor

Hi

I have a problem finding the solution to this question.

Can anybody help ?

Kr / Per Hunosøe

Super User

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.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
New Member

So how could we show the difference between two figures?

Super User

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

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
New Member

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

Super User

@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

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.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Frequent Visitor

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

Frequent Visitor

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

Thanks,

Vida

Frequent Visitor

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

Helper II

Hi

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

Thanks

Alexander

Frequent Visitor

Hi

I have a problem finding the solution to this question.

Can anybody help ?

Kr / Per Hunosøe

New Member

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

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

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

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

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

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors