Forum Discussion
up arrow / show a shape based on a formula
Community ChampionAuraCorp - Can you provide a little more information on what you are trying to accomplish? I'm not following what you are trying to do.
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.
Alexander24Helper II
Hi
How did you format the image url? I get just a link when i do it?
Thanks
Alexander
- ruthpozuelo
Post Prodigy
Hi Alexander,
It is not an image but a symbol within a DAX measure.
Maybe this helps:
https://youtu.be/7oCygwn75tQ
/Ruth
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
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
instead of Matrix, you have to use use tables to be able to display the image. Matrix doesn't work.
Thanks,
Vida
- greggyb
Resident Rockstar
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
