Forum Discussion
Image based on slicer selection - broken link
Hello,
I am trying to get an image to appear when the person selected by the slicer is approaching their 25th reunion.
I created a new column using the formula below, and categorized it as Image URL. The viz is a table. The image is saved in a google drive and the access is set to "anyone with the link"
It is working, in that the broken image icon shows up when a person in the 25th window is selected, and nothing shows up when someone outside the window is selected. I just can't figure out why the link is broken. Any ideas?
Thank you!
Formula:
After some Googling, it appears to work if you change the URL to this format, with the image ID following the final forward-slash:
https://lh3.googleusercontent.com/d/1C5D9M8RStdDVK0nYLu_RSgYBjnMbEl-TThe calculated column expression for this URL would then be:
25th Image test = IF ( 'SDO Query'[Reunion Window Ind] = "25th Window", "https://lh3.googleusercontent.com/d/1C5D9M8RStdDVK0nYLu_RSgYBjnMbEl-T", "" )Does this work for you?
2 Replies
After some Googling, it appears to work if you change the URL to this format, with the image ID following the final forward-slash:
https://lh3.googleusercontent.com/d/1C5D9M8RStdDVK0nYLu_RSgYBjnMbEl-TThe calculated column expression for this URL would then be:
25th Image test = IF ( 'SDO Query'[Reunion Window Ind] = "25th Window", "https://lh3.googleusercontent.com/d/1C5D9M8RStdDVK0nYLu_RSgYBjnMbEl-T", "" )Does this work for you?
Yes! It worked, thank you so much!
It's actually showing up very tiny, but I'm sure I can adjust the formatting. It's always something 😂
