No Data - Hide Visual and Hide Page Dynamically

[Prakash1050]

Hi All,

        I need to hide the visual dynamically when no data.

I have three table visual below pic.

       If I filter one date in the filter pane.

   The first table have no data.

   I need to hide that no data visual automatically.

   or the other visuals are present in top order automatically.

   If the All other visual also have no data. The Hole Page is hide or Invisible automattically.  

   It can done any other technology used in powerbi?

   Help me to achieve this scenario.

   Thanks in advance.

[Gayatri_D05]

Hi @Prakash1050 ,
Theres no such funtionality to hide visulas in Power BI yet. Howvever a work round is to set the conditional formatting settings for all the parts of visuals like Data, Title, Border if any, to a condition that if Data is not present change the colour to transparency, something like this :
mask_transparency =IF(Data = blank(),”#FFFFFF00″,”#FFFFFF”)
But even with this you wont be able to change the position of other visuals or something, It'll just hide your cuurent visual and the space would be just white.

If your requirement is solved, please make THIS ANSWER as SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.😊