Using an icon from Flat Icon (PNG) inside of a card showing variances

[josephliverpool]

Hi

I hope someone can help because I'm pulling my hair out here. Can anyone point me in the direction of a resource which can help me do the above?

I want to be able to download a .png from Flat Icon and use this in a card to show the variance. I have used the below measure which works, however I'm struggling to swap the Unichar section to the Flat Icon which I have saved in SharePoint.

I have created a table in Power BI which is called 'Images' and the headings and any help would be absolutely incredible!

Name of Icon	URL
Red_down_arrow	Sharepoint URL is here  and is formatted as an image url

MTD Revenue vs Budget =

VAR Up_Arrow = UNICHAR(129137)

VAR Down_Arrow = UNICHAR(129139)

VAR Target = [MTD Revenue]-[Budget]

VAR target_percent = FORMAT(DIVIDE([MTD Revenue],[Budget],0),"0%")

RETURN

IF(Target <0, target_percent&" "&Down_Arrow,

target_percent&" "&Up_Arrow)

[josephliverpool]

Never thought of trying that, what measure did you use for the image URL?

[Kaviraj11 · Accepted solution]

You can create a measure and make sure your measure data category is set to Image URL

Image URL = CONCATENATE("https://abcde.sharepoint.com/",CALCULATE(VALUES('The Images'[File.ServerRelativeUrl]),FILTER('The Images','The Images'[File.Name]="ArrowUp.png")))

Image URL1 = CONCATENATE("https://abcde.sharepoint.com/",CALCULATE(VALUES('The Images'[File.ServerRelativeUrl]),FILTER('The Images','The Images'[File.Name]="Arrowdown.png")))

A little trick for SharePoint Online Images in Power BI (youtube.com)

[Kaviraj11]

Here is a working solution on my end. I use a Card(New) and have the metrics shown on the value and created a separate measure for an image

Image=Switch(true(),Target <0, target_percent,[Image URL],[Image URL1])

Put this measure in the image section.