Forum Discussion

BeginnerBI's avatar
BeginnerBI
Helper I
1 year ago
Solved

Display dynamically multiple images in the selected value.

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 bree...
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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's avatar
BeginnerBI
Helper I
1 year ago

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's avatar
    Anonymous
    Not applicable
    1 year ago

    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.