Forum Discussion

atult's avatar
atult
Icon for Advocate I rankAdvocate I
4 years ago
Solved

Hide/Show Visualization according to Slicer Selection

Hello Experts, We are facing difficulty in a scenario of having multiple bookmarks in a page.  If we use page navigation + Bookmarks, the no. of pages exceeds 10 for all combinations which is affec...
Need Help
  • Anand24's avatar
    Anand24
    4 years ago

    Hi atult ,
    You can't show/hide visualation with slicer dax such that you will be able to hover over visualization at back.
    You can make the visualation transparent but can't completely remove/hide it like bookmarks.

     

    Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

    Proud To Be a Super User !!!
    LinkedIn
marcelsmaglhaes's avatar
marcelsmaglhaes
Icon for Super User rankSuper User
4 years ago

Hey atult ,

 

 You can use a card visualization over the tables and control the visibility with a measure, configuring the background color. 

 For example, you can create a measure like below, and put that in Effects -> Background using Fx.

 

 If there some dificulty to do that, you can read this article: Show or Hide a Power BI Visual Based on Selection ✅ - Excelerator BI

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

Regards, 
Marcel
Measure

hide_card_viz1 =
IF(
selectedvalue[viz] = "Viz1",
"#FFFFFF00", -- color that make card visible
"#FAFAFA" -- color that covers the card
)
atult's avatar
atult
Icon for Advocate I rankAdvocate I
4 years ago

Hi marcelsmaglhaes ,
Thanks for the reply.

I actually have 2 visualizations overlayed over each other. Hence, can't use this dax since even with transparent background, my visualization at back won't be hoverable or clickabe.