Forum Discussion

JustinDoh1's avatar
JustinDoh1
Post Prodigy
1 year ago

How do I show/hide these visuals (based on filter selection)?

Hi,

I was trying to get some feedbacks for an sample for about a week, but I have not gotten yet, so I am posting here again.

I have uploaded my PBIX file here.

 

I have three visuals that I would like to show and hide based on selection from a filter (Location).

 

These visuals were created using Parameter. I am not sure if that makes any difference.

I also tried to create relationship between these three visuals and dim table (Location), but nothing changes.

 

Somebody mentioned about solution using RLS, but I am not sure how I approach it.

 

But, after watching several YouTube contents on this topic, I found some solutions by putting another layer over visuals and use a white color to cover based on selections.

Is it the optiomal solution?

 

Thanks.

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi JustinDoh1 ,

    Agree with you on that last solution, it's relatively simple to implement.

    If you want to hide visual when you select all, try this

    Color = 
IF(ISFILTERED('Location'[ProviderName]),"RGBA(255,255,255,0)","RGBA(255,255,255,1)")

    Use this measure to set the background color of the inserted graphic.

    Final output

     

    Best Regards

     

    • JustinDoh1's avatar
      JustinDoh1
      Post Prodigy
      1 year ago

      Anonymous Thank you so much for your feedback.

      I think the issue I am facing is, if I have a cover (shape) on the top of "parameter" visual, I cannot drag the parameter. I think this method works if visual that I am covering does not have to be interactive.

       

      So, my next approach was applying conditional formating on each parameter itself, but even doing that, it would not change color as I expected.

       

      I created three measures for each conditions (like below).

      ALI Cover = IF(SELECTEDVALUE('Location'[ProviderName]) in {"ALI"},"White","Blue")

       

      I have uploaded my latest PBIX file here.

       

       

       

       

       

      Is there any way I could use RLS by chance?