Looker Community

Showing product images in a dashboard

Hello everyone,

I would like to show product images in dashboards - I’ve created a dimension that allows me to show the product images inline, but this takes up a lot of space. What I would really love to do is have the images show up when the user hovers over a product code - is this possible in Looker?

I also wondered if it may be possible to have a text tile showing an image, which could update dynamically as the user clicks on other SKUs, is this possible?

Best,
Ben

I can’t think of a way to do this one. Text tiles on dashboards are pretty much static, they don’t take any kind of liquid or dynamic input.

There’s also no way to have the tooltip HTML be different than the inline HTML, I’m afraid. Both good ideas that would make for some pretty dashboards!

1 Like

izzy - when cross-filtering gets released later in the year would this be possible with a single value field with HTML applied with Liquid embedded and automatically-triggered refreshing on the tile?

Yurp, totally. That was the first thing that jumped to my mind as well, but the operative words there are “later in the year” :slightly_smiling_face:.

Good lookin’ out Ben!

@izzy @bens What is this cross filtering magic of which you speak? :dizzy:

It’s a feature that’s currently in the works that’d allow you to click on a value on one dashboard tile and have it filter other tiles on the dashboard with that value. Will make all kinds of interesting things possible!

You could potentially use the <details> in HTML, for example:

  dimension: dimension_with_picture {
    type: string
    sql: ${TABLE}.column_in_table ;;
    html:
   <details>
     <summary>{{ value }}</summary>
     <p><img height="100" src="{{image_link._value}}"></img></p>
   </details> ;;
  }

gets you:
details

2 Likes

Love this, thanks @brecht!

Genius! Would it be clickable like that in the tooltip, as well?

I don’t think so, tooltips disappear when you no longer hover over the data point, so if you’d hover over the tooltip, it’d disappear too.

When can we expect cross filtering to be available?

This one is still being worked on but without a committed release version, so I can’t speak to a specific date. I’ve mentioned elsewhere that there are general dashboard improvements coming— So rather than build cross-filtering for our current dashboards, release it, and then have to re-model for the new dashboards, we’re building it as part of the new dashboards.

It’s not part of the first “milestone” of the new dashboards, so you’ll likely see earlier beta features of them that do not include cross-filtering, but eventually it’ll be there.

I realize that’s a pretty darn vague answer— I’d give more clarity if I could.

Ok, thanks for the prompt reply Izzy! Look forward to the new dashboards and hopefully, the cross-filtering as well, soon!

Also, can you point me to any discussion on the “new dashboards” please? Would be keen to understand the potential features. Thanks!

There’s really not much discussion on them, I think what little I’ve said about them I probably shouldn’t have :zipper_mouth_face:. They’ll be announced to much fanfare when they finally are, so keep an eye on those release notes!

1 Like

Hi @brecht, just a quick heads up, looks like the new table (beta) breaks this functionality. It would be great to see it working with table V2!

Ben

We recently noticed this one ourselves. If you deselect “Truncate Text”, it should start working again (but it may not re-size back to the smaller width once you close the dropdown. Let us know)
image

We have it filed and our engineering team’s aware, but it hasn’t been prioritized yet. Let us know if turning off Truncate Text does the trick!

Hi @izzy,

Thanks for the feedback! I tried toggling ‘Truncate text’ off and it does help embedded images not appear squashed (see below) but the html: toggle still does not work.

Embedded images with truncate on:
Truncated

Embedded images to truncate off:
Un-Truncated