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 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.

4 Replies

  • 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.

  • Selva-Salimi's avatar
    Selva-Salimi
    Solution Sage
    1 year ago

    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.