Forum Discussion

imy's avatar
imy
Icon for Helper I rankHelper I
7 years ago
Solved

Hide empty tables and text boxes

Hi, I wonder if is possible to hide a table if is empty. I have a table and this is filtered by different directorates and months/year. However, in some directorates, there is no data in certain months. It is possible to hide totally that table (I mean the column titles), or conditionally format the column titles to white so it is not visible?.

Also, is it possible to do this on a text box (so this disappears if the table is empty)?

 

Many thanks!

Imy

  • imy ,

     

    I'm afraid conditional formatting can not format the column headers in table visual. You can also not remove the whole visual if there's no value represented in it.

     

    Regards,

    Jimmy Tao

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support

    imy ,

     

    I'm afraid conditional formatting can not format the column headers in table visual. You can also not remove the whole visual if there's no value represented in it.

     

    Regards,

    Jimmy Tao