Display dynamically multiple images in the selected value.

[BeginnerBI]

Hello, and thanks in advance.

Objective: Allow the user to select a store from a dropdown slicer. Based on the selection, display images representing customer purchase amounts with different breeds of dogs.

Example Workflow:

1. The user selects "Chicago" from the slicer.
2. Chicago has 5 customers:
   • 2 customers made purchases over $300.
   • 2 customers made purchases over $500.
   • 1 customer made a purchase of $1000.
3. Based on these purchases:
   • For purchases over $300, show a Corgi.
   • For purchases over $500, show a Golden Retriever.
   • For the $1000 purchase, show a Doberman.

Outcome: Once the store is selected, 3 dog images will be displayed, corresponding to the different purchase tiers.

[Anonymous]

Hi @BeginnerBI 

First, create a table that includes different dog breeds and their corresponding images.

Set the picture column to the image URL format.

Create a new table that includes stores and the amount spent.

Create a new column:

Breed = IF([purchases] > 1000 ,"Doberman",IF([purchases]>500,"Golden Retriever","Corgi"))

Create a new relationship:

Result:

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[BeginnerBI]

Hi Jayleny,

Thank you so much but what I have been trying to do is have one selection and instead see multiple rows and I would like to have multiple images.  when I click chicago dinamycally display the count of record for those breeds in that location.  Chicago have 5 doberman and 2 corgies, I select and pop up 7 images.  I'm not sure if this is possible. but it is like the vision for the scope.

[Anonymous · Accepted solution]

Hi @BeginnerBI 

You can use the Image Grid custom visual:

Sample table:

Visual settings:

Result:

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Selva-Salimi]

Hi @BeginnerBI 

I am not sure if I understand your expectation. but based on my understanding you can write a measure as follows:

if (sum(purchase)>=300, "🐶", if( sum(purchase)>=500 "🦮" , .... )

for other you can search for emojies and icon.

If this post helps, then I would appreciate a thumbs up  and mark it as the solution to help the other members find it more quickly.