Dynamically change images from local system in PBI report based on column value

[Sm95]

Hello all,

I have a requirement to dynamically switch images in PBI report based on my calculated column value. The images (.png) are present in my local system. I have seen multiple posts describing the use of URLs for switching images, but is there any way to do so when the images are in my system folder?

Below is the calculated column logic based on which I want to switch the images.

Change Pct Direction = IF([CHANGE_PCT] > 0 , 1 , IF([CHANGE_PCT]<0 , -1 , 0))

If value = 1, then I need  image to display else  image. There are few other scenarios where I need different set of images to be switched. Please suggest any possible workarounds/solutions for the same.

Thanks!

[amitchandak]

@Sm95 ,

In the same formula return the image URL . Better have these images on a public URL or one drive where an organization can have access

Change Pct Direction = IF([CHANGE_PCT] > 0 , "<Path>\image1.png" , IF([CHANGE_PCT]<0 , "<Path>\image-1.png" , "<Path>\image0.png"))

You can also try using unichar, if you find a suitable one

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

https://exceleratorbi.com.au/dax-unichar-function-power-bi/

[Sm95]

Thanks @amitchandak . Does this mean this requirement can be achieved only if the images are on a public URL? Any way we can do it by providing the folder location of the images in my system?

[v-shex-msft · Accepted solution]

HI @Sm95,

>>Does this mean this requirement can be achieved only if the images are on a public URL? Any way we can do it by providing the folder location of the images in my system?

Yes, current power bi not able to recognize and analyze image links with redirect or authorization.

Please use the 'public link' directly located to the root image files(e.g. xxxx.xxxx.com/abc.img) that do not include any redirection or authorizations.

Regards,

Xiaoxin Sheng