cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

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

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.

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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.

View solution in original post

3 REPLIES 3
Highlighted
Super User IV
Super User IV

@dscott73 , you use isfiltered or hasonevalue

 

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

 

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

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Microsoft
Microsoft

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.

V-lianl-msft_0-1603784443235.pngV-lianl-msft_1-1603784454968.pngV-lianl-msft_2-1603784488448.png

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.

Highlighted

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.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors