Forum Discussion

Kalaivani's avatar
Kalaivani
Icon for Helper III rankHelper III
1 year ago
Solved

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

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!!!!!

 

Need Help
Show and Tell
Tips and Tricks

4 Replies

    • Kalaivani's avatar
      Kalaivani
      Icon for Helper III rankHelper III
      1 year ago

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

  • WishAskedSooner's avatar
    WishAskedSooner
    Icon for Continued Contributor rankContinued Contributor
    1 year ago

    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's avatar
      Kalaivani
      Icon for Helper III rankHelper III
      1 year ago

      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.