Simple Image Visual will not go away when slicer unselected

[mehlenbae2]

Hello,

I have a Simple Image visual that shows up ONLY when any value is selected from my "Sim ID" slicer. This works perfectly until I select a value in the "Sim ID" slicer and then UNSELECT the value in the slicer, the Simple Image visual will not go away.

I have a measure called "Show Simple Image":

Show Simple Image =

IF (

    ISFILTERED ( 'Campaigns'[Sim ID] ) && COUNTROWS(ALLSELECTED('Campaigns'[Sim ID])) > 0,

    1,

    0

)

Any idea of how to fix this?

[Anonymous]

Hi @mehlenbae2 ,

I create a table as you mentioned.

Then I change your DAX code and here is the DAX code.

Measure =
IF (
    ISFILTERED ( 'Campaigns'[Sim ID] )
        && NOT ISBLANK ( MAX ( 'Campaigns'[Sim ID] ) ),
    1,
    0
)

Best Regards

Yilong Zhou

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

[mehlenbae2]

Hi there,

I tested this and it still does not work. I will attach a test PBI to this comment.

Here are my requirements for functionality:

1. The photo (Simple Image) should NOT show when nothing is selected in either the "Date" slicer or the "Sim ID" slicer.

2. The photo (Simple Image) should NOT show if a value in the the "Date" slicer is selected.

3. The photo (Simple Image)  SHOULD ONLY show when there is a value selected in ONLY the "Sim ID" slicer.

4. The photo (Simple Image) SHOULD dissapear when a value in the "Sim ID" slicer is no longer selected.

Attached is my TEST PBI. This is the exact format I have in my MASTER pbix file.

Link: PBI: https://www.dropbox.com/scl/fi/poywqhwmi9bgjw6n5hrvw/TEST5.pbix?rlkey=cxy49gxbxw0dj5cjis2du9tod&dl=0

[Anonymous]

Hi @mehlenbae2 ,

It seems that I can not open the .pbix file. Could you please change a way to upload the file?

Best Regards

Yilong Zhou

[mehlenbae2]

Try this link: 

https://drive.google.com/file/d/1L-wp0R-0TUVSfX3wrPrLu99xtfGKvKrx/view?usp=sharing

[Anonymous · Accepted solution]

Hi @mehlenbae2 ,

Thank you and I successfully opened your .pbix file.

I think you can change the 1 and 0 in the measures named Hide Line Chart and Show Simple Image.

Hide Line Chart = IF(
    ISFILTERED ( 'Campaigns'[Sim ID] ),
    0,
    1
)

Show Simple Image = 
IF (
    ISFILTERED ( 'Campaigns'[Sim ID] ) && COUNTROWS(ALLSELECTED('Campaigns'[Sim ID])) > 0,
    0,
    1
)

Then I think it will achieve your requirements.

Best Regards

Yilong Zhou

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