Interactive Image

[Anonymous]

Hello Community,

I'm willing to create a measure that returns an image that changes depending on another measure.

Here is my DAX formula

Mesure 11 = IF([Mesure 4   =0;"https://t.pimg.jp/033/530/640/1/33530640.jpg" ; "http://moziru.com/images/red-cross-clipart-circle-1...")

This formula is working perfectly , but my problem is that if the user have no internet he cannot see the pictures since Power BI import it from internet everytime.

I want to download the pictures once on my computer and link it with the measure without having access too internet

I wish i was clear and thank you in advance

[PattemManohar]

@Anonymous Just wandering, if there is no internet how can the user can access the Power BI Service to access the reports and dashboards ? 

[Anonymous]

PowerBI spends too much time downloading the pictures everytime i run the project because i have more than 40 measure. I want to improve that point

[PattemManohar]

@Anonymous  Ok ! Thanks for confirming that.. In that case, store the images in a database table and use the image field (binary format) in Power BI. Here is the useful thread about storing the images in SQL Server table and accessing in Power BI.

https://community.powerbi.com/t5/Desktop/How-to-use-Images-Stored-in-a-SQL-Server-Table-with-Power-BI/td-p/383111

[Anonymous]

Thank you for your answer , i did try that., I created a query with the pirctures in binary format : It works when you want to simply display the images.

In my case i want to link it with a measure , when it's zero it shows a picture , when it's not it shows another

[PattemManohar · Accepted solution]

@Anonymous Yes, why can't you have an another field call it as Flag. Then flag with "Y" for one image and another one with "N". Use the Flag filter in to get the appropriate image and use that in your IF statement.