Forum Discussion

mehlenbae2's avatar
mehlenbae2
Icon for Helper II rankHelper II
2 years ago
Solved

Simple Image Visual will not go away when slicer unselected

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...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.