Select all slicer with images

[Rajesh26]

I have a slicer for selecting countries in world. I have managed to show the corresponding flag of the country when a country is selected. but I want to know how to show the worldmap image when the slicer is on select All.

Need your help to fix this select all slicer with image.

[Anonymous]

Hi @Rajesh26 ,

Due to the design of Power BI Desktop, unfortunately there is no direct way to reach your needs. 

You can post your idea to Ideas.  https://ideas.powerbi.com/ideas/

You can use the following methods instead:

1.First we need to prepare such data. Please refer: Display images in a table, matrix, or slicer in a report - Power BI | Microsoft Learn

2.Select that column. On the Column tools ribbon, for Data category, select Image URL.

3.Changing aliases to spaces.

Then the result is as follows.

Best Regards,

Neeko Tang

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

[Rajesh26]

Thank you for your input. I already tried the same, it does not work. In my report, I have multile slicer with multiple dropdowns.

First slicer have the images and other slicers didn't have any images.

when first slicer specifies one value, have to show that images. When First slicer is All select, it doesn't show any image on the page.

[Anonymous · Accepted solution]

Hi @Rajesh26 ,

This is my test data.  

We can create a measure.

Measure = IF(ISFILTERED('Table (2)'[country]),MAX('Table (2)'[url2]),MAX('Table (2)'[url1]))

Best Regards,

Neeko Tang

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

[Rajesh26]

Hi @Anonymous 

Thank you for your valueable inputs, it works good. I accept you solution.

with many thanks,

Rajesh

[tharunkumarRTK]

@Rajesh26 

Have you tried using the new Button slicer, I think you can put different images with it for selected and deafult state. But I am not sure weather you can conditioally change the image.

https://powerbi.microsoft.com/en-us/blog/new-slicer-button-public-preview/

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

[Rajesh26]

I tried the same, Thank you for your input. but I have multile slicer with multiple dropdowns.

First slicer have the images and other slicers didn't have any images.

when first slicer specifies one value, have to show that images. When First slicer is All select, it doesn't show any image on the page.

[Rajesh26]

Hi Thanrun,

Thank you for your information, Which is really helpful. This is not fulfill the actual requirements. Can you please share some other inputs.

[Rajesh26]

Hi all,

Here one example...

For simple image visual only selects column values instead of measure. even if create a calculated column, which always shows blank.

I have used this code, which does not work. Please help me to resolve this.

ImageToShow = IF (

HASONEVALUE( 'Portfolio logo'[Portfolio] ),

MAX ( 'Portfolio logo'[ImgToBinary] ),

LOOKUPVALUE ( 'Portfolio logo'[ImgToBinary], 'Portfolio logo'[Portfolio], "ALL" )

)