topic Re: Display dynamically multiple images in the selected value. in DAX Commands and Tips

Display dynamically multiple images in the selected value.

BeginnerBI — Wed, 18 Sep 2024 14:11:39 GMT

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:

The user selects "Chicago" from the slicer.
Chicago has 5 customers:
- 2 customers made purchases over $300.
- 2 customers made purchases over $500.
- 1 customer made a purchase of $1000.
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.

Re: Display dynamically multiple images in the selected value.

Selva-Salimi — Wed, 18 Sep 2024 18:16:57 GMT

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.

Re: Display dynamically multiple images in the selected value.

Anonymous — Thu, 19 Sep 2024 01:54:50 GMT

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.

Re: Display dynamically multiple images in the selected value.

BeginnerBI — Thu, 19 Sep 2024 20:04:34 GMT

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.

Re: Display dynamically multiple images in the selected value.

Anonymous — Mon, 30 Sep 2024 02:40:04 GMT

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.