Dynamic sets of images based on filter

[Dz6kb4]

Hi all.

i couldn't find an exact answer to my question on the search. I'm basically looking for a way to dynamically display a range of images depending on a filter selected.

for example, if I have a report on foods I might have a food filter including meat, fish, veg.

when I select meat I want to show an image of chicken, pork and beef with a total calorie per 100g under each one.

if I then select fish I want to dynamically remove the meat images and replace with tuna and salmon images and their associated calorie counts.

is this at all possible?

many thanks.

[Vvelarde · Accepted solution]

@Dz6kb4

check this PBIX:

https://drive.google.com/file/d/0B95C8CKdTZE3Rm8xLXNfUTN4aFU/view?usp=sharing

[aditya_fractal]

Hi all,

The solution proposed is working perfectly. However, just wanted to know if there is any way to avoid the ImageURL. For example: what can we do if the images are not available on the internet.

Thank you!

[aditya_fractal]

One of the solutions I found is to convert the image into Base64, store it in my model & use it from there.

If anyone comes across a better way of doing this, I would request you to share it with all of use here.

Thank you!

[smsantos31]

Hello!

I followed the instructions but I cannot display the image, and when I tried downloading the pbix file with the DEMO, the same happens. Could it be a restriction of the local network?

Thanks!

 Check my screenshot here: SCREENSHOT, I couldn't upload the image. 

SS

[aki]

Hi,

The same thing has happened to me with regards to the images not being displayed correctly. Did you manage to resolve this? I have tried uploading the URLs in an Excel data table and also typed manually directly into PBI - neither have worked.

Would be grateful for a response.

Aki

[lu_vynn]

Hi,

Have you put your URL data as Image URL? In the Modeling tab:

[smsantos31]

Hello!

I followed the instructions but I cannot display the image, and when I tried downloading the pbix file with the DEMO, the same happens. Could it be a restriction of the local network?

Thanks!

 Check my screenshot here: SCREENSHOT, I couldn't upload the image. 

SS

[aki]

Hi,

The same thing has happened to me with the image not being displayed. I've tried uploading an Excel sheet with URLs and also typed the data directly in Power BI.

Did you find a solution?

[Vvelarde · Accepted solution]

@Dz6kb4

check this PBIX:

https://drive.google.com/file/d/0B95C8CKdTZE3Rm8xLXNfUTN4aFU/view?usp=sharing

[Anonymous]

What if the image I want to display is a screenshot form my PC, and does not have a URL?

[aditya_fractal]

@Anonymous You can convert any image you want to use inside POWER BI into base64 format using any of the websites available & use the generated base64 string.

Hope it helps!

[Dz6kb4]

Wow, brilliant, had now idea you could do that, thanks alot.

I forgot to add an extra level of complexity however - if I replaced calories with amount eaten and that amount eaten changes depending on the month, would I be able to use this technique still?  I.e if I select Jan and meat - have all the meat images and just the jan amount eatens shown?

Many thanks

[Dz6kb4]

@Vvelarde if you can help pls? 🙂

[Vvelarde]

@Dz6kb4

Yes, still work. Just add a slicer with the months.

[Dz6kb4]

@Vvelarde thanks again.  But presumably I will need to have one of the records in your table for each month of the year if I want to change the values and images  by month?  Just wondering if there is a better way to do this?

Many thanks.

[v-yuezhe-msft · Accepted solution]

Hi @Dz6kb4,

Yes. Based on Vvelarde's sample data, you would need to have one of the amount eaten records in table for each month of the year as shown in the following screenshot.

However, to better manage your tables, I would recommend you separate the Food table to two tables,  then create relationship between the two tables using type field. For more details, please review the modified PBIX file.

Thanks,
Lydia Zhang

[Dz6kb4]

Excellent, thanks very much both

[v-yuezhe-msft]

Hi @Dz6kb4,

You can accept multiple helpful replies as answer, this way, other community members would easily find the answer.

Thanks,
Lydia Zhang