Forum Discussion
Solved
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 UR...
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?
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-T
The 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 😂