Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
anithaMallam
Helper III
Helper III

Need Help on show/hide visuals with slicer

Hi All,

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

anithaMallam_0-1631010309689.png

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.

1 ACCEPTED SOLUTION
v-kelly-msft
Community Support
Community Support

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:

vkellymsft_0-1631253016817.png

vkellymsft_1-1631253033262.png

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

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

View solution in original post

2 REPLIES 2
v-kelly-msft
Community Support
Community Support

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:

vkellymsft_0-1631253016817.png

vkellymsft_1-1631253033262.png

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

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

selimovd
Super User
Super User

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
 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.