Forum Discussion
Helper IIIHide image not found icon
Ahh, you are just pre-empatively creating the URL and it may or may not exist. I thought you were getting broken images because you didn't have a URL for certain products.
Unless you can source the actual valid URLs instead of creating them, I'm not sure how to surpress/or swap out the broken image. There are 3rd party Matrix/Image visuals out there, perhaps one of them won't show that broken icon.
Power ParticipantI do mean that, except I think I do Transform Column > Replace Values step on the url column that says "replace null with (your no image link)".
Or you could create a new custom column with "if imagelink = null then (your no image link) else imagelink".
Helper IIISo there is another bit of info worth mentioning. The images links are created like this;
Table.AddColumn(#"Renamed Columns1", "Merged", each Text.Combine({"https://www.website.com/images/", Text.Trim([STYLE]), ".jpg"}), type text)
So the link is created whether the ftp has the image loaded or not. So all rows in the data have a link. Do your solutions above apply in this case?
- cassidy
Ahh, you are just pre-empatively creating the URL and it may or may not exist. I thought you were getting broken images because you didn't have a URL for certain products.
Unless you can source the actual valid URLs instead of creating them, I'm not sure how to surpress/or swap out the broken image. There are 3rd party Matrix/Image visuals out there, perhaps one of them won't show that broken icon.- gaiusgw
Yeah that's what I thought. Figured it was a long shot for it to validate the URLs. Thanks for your help