Forum Discussion
up arrow / show a shape based on a formula
Community ChampionAuraCorp - 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.
Helper IIHi
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- 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!!
- ruthpozueloGreat! Glad it worked! I am still waiting for native KPIs in power bi...
Have a great evening :)
/Ruth
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
Hi
I have a problem finding the solution to this question.
Can anybody help ?
Kr / Per Hunosøe
