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

[JustinDoh1]

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.

[v-zhouwen-msft]

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]

@v-zhouwen-msft 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?