Need Help on show/hide visuals with slicer

[anithaMallam]

Hi All,

         Need your help on the below scenario. i have a report page with slicer and visuals as show below

when i select oee in the slicer only the left hand side visual with target show be shown and the other visual on right sideshow be hidden and for the other selections in the slicer the right hand side visual without targets should be shown and the left side visual should be hidden.

i could able to do it with buttons and bookmarks but with slicer iam not able to.

could someone of you please help me on this.

Regards

Anitha.

[v-kelly-msft · Accepted solution]

Hi  @anithaMallam ,

Create 2 measures similarly as below:

Measure = IF("OEE" in FILTERS('Table (2)'[Selection]),SUM('Table'[Target]),BLANK())

Measure 2 = IF("OEE" in FILTERS('Table (2)'[Selection]),BLANK(),SUM('Table'[Other]))

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my raeply as a solution!

[selimovd]

Hey @anithaMallam ,

I still think Bookmarks would be the better option.

However, if you want to avoid that, you can put a shape above the visual that you want to show or hide. Then you have to create a measure for the color of the shape. If you want to hide visual, the shape should have the color "#FFFFFF" what is simple white. If you want to show the visual underneath the visual the shape should get the color "#FFFFFF00" what is transparent.

This logic you have to build into a measure.

That's also the only approach that I know that would work with a slicer.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic