how to hide a matrix visual (including headers) when nothing selected from a filter in power bi

[Kalaivani]

I have a matrix visual where I added a filter called ShowVisualCompare so that the matrix values will show up only when ShowVisualCompare =1 

Measure : 

ShowVisualCompare =

IF(

    ISFILTERED('Comp Providers Compare'[ProviderName])|| ISFILTERED('Comp Providers Compare'[Clinic Manager]) || ISFILTERED('Comp Providers Compare'[DCO]) || ISFILTERED('Comp Providers Compare'[AACMO]) ||ISFILTERED('Comp Providers Compare'[VP])|| ISFILTERED('Comp Providers Compare'[Org Code]),

    1,

    0

)

But matrix headers are showing up even when the matrix is blank. Here is what am getting. I tried adding the text box with transparency 100 to show a message. But am not able to hide the headers:(

Thanks in advance for any of your help!!!!!

[WishAskedSooner]

There are a couple of approaches to this requirement:

1. If you want to hide certain visuals based on slicer selections, then Bookmarks are probably the simplest method assuming you are not trying to get too tricky.

2. Another is to modify your measures to return BLANK() if nothing is selected.

Good luck!

[Kalaivani]

Hi @WishAskedSooner Thanks for the suggestion. Actually it has be to shown/hidden based on a condition. The condition checks if any value from a filter is selcted. If so, show the visual else hide the visual. But bookmarks are not helping in this. The problem is am able to hide the visual values but headers are showing up.

[Fowmy · Accepted solution]

@Kalaivani 

I solved a similar problem some time back by using a Card visual on top of the matrix visual. Please check the attached file and adapt accordingly for your case.

In my scenaio, I wanted the visual to be visuble only when Friday is selected.

[Kalaivani]

Hi @Fowmy Thanks so so much for your suggestion. It is working for me now!!!