Defaul Logo Image when "All" or "None" selected in slicer

[dscott73]

The scenario is, I have a report with multiple companies, A, B and C.  Each has their own logo, but they are "owned" by a "master company".  Currently I have the report dynamically changing the logo and data with each selection of the Company via a slicer.

The issue is, with a slicer when no selection is made (and single selection is not turned on) it is equivalent to "All Selected".

How can I show a default Logo for this "Master Company" when no selection is made on the Company slicer (All Selected)?

I was thinking of maybe a helper/bridge table but not sure how to configure this.

[V-lianl-msft]

Hi @dscott73 ,

What kind of visual do you use? I checked "image of cloudscope" visual and found that the default image and conditional formatting could not be set.

So I use card visual to hide image visual as an alternative.

You can refer to this blog on how to set conditional formatting for card visual.

https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/ 

Sample .pbix

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

[dscott73 · Accepted solution]

In my scenario I have a table loaded with .png's which have been converted to Base64. 

In my first method, I am using the "Simple Image" visual:

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381835?tab=Overview

I found that if the first image in my table becomes the default image.  In this instance I named it "ALL.png".  When nothing is selected, it will display.  However, this behavior is implicit.

The other method I found I could implement was to use a Table.  The table is 1x1.  I place the measure in the Values slot under the fields.  I use this measure:
Logo =
IF (
ISFILTERED ( 'Sample Logos'[CompanyID] ),
MAX ( 'Sample Logos'[LogoImage] ),
LOOKUPVALUE ( 'Sample Logos'[LogoImage], 'Sample Logos'[CompanyID], "ALL" )
)

Not perfect, but it seems to be working so far.

[sunilbeckham]

Hi. I'm stuck on the same problem. I'm trying to replicate your solution but the visual 'Simple Image' only accepts field Image URL and not a measure. Could you please clarify how you were able to use a measure there?
Thanks in advance

[amitchandak]

@dscott73 , you use isfiltered or hasonevalue

if(isfiltered(Table[company]), [Url1], [Url2])

refer my video on both :https://www.youtube.com/watch?v=hXg3kRFSGjA

[Rajesh26]

Hi all,

I am also facing the same and the given otion is not working. simple image visual only selects column values. even if create a calculted 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" )

)