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 woul...
Need Help
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?