How to display Image as blank in matrix visual when there is no image instead of small image icon

[gp_12]

Hello Team,

I have been trying to explore about adding images to the matrix from the records stored in Azure SQL Database. The image displays fine when there is a record in the table but when the entry is blank it still shows a small image icon, Is there any way I can get rid of it so that when there is no Image the visual should be blank and when there is record it should populate the image in order to avoid the confusion. 

Following is the screen shot of the issue which I am facing :

As you can see above , there is no image record in the database and hence its showing a small icon which I dont want. Is it possible ? or can anyone guide me with some reference links please.

Thank You,

Gp

[lbendlin]

how are you getting the image URL? is it via a column or a measure?

[gp_12]

Hello @lbendlin 

Image URL is a column which I have added in the table visual.

I have followed "https://www.sqlshack.com/working-with-images-in-power-bi-desktop-reports/" this article as I get my Image url column from SQL database. 

Also used this "https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-images-tables" this article for reference.

Thank you,

Gp

[lbendlin]

Make sure the Power BI service has direct access to these image URLs without the need for authentication.  It would be better to embed the images in the Power BI dataset.

[gp_12]

Power Bi service can access the image when its available in the database. In my image url column in table in sql database , some records are null while some have value in them. When I dispaly this in power bi matrix visual , the records which have value displays the image properly but the records which are null should not display an image , it should be blank, But in my scenario I get the small image icon which states that the record in the database in null. I am trying to display it as below when there is no record :

There should not be any small image icon for null record.

Thank You,

Gp

[lbendlin · Accepted solution]

substitute the null records with a small (single white pixel) image.