Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hiding columns if blank

Hello,   I am currently having issues with the following case:   I have a table that groups different types of information, with 40 columns, but each case has values in a different columns. Examp...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    That was something I was almonst certain, but maybe there is some who knows a trick or a custom visual that allows to do this basic task.

     

    Thanks,

    Antonio

    • zoloturu's avatar
      zoloturu
      Icon for Memorable Member rankMemorable Member
      8 years ago

      Anonymous,

       

      You can play with R scripting in a way to remove columns (which called variables in R) if first value in column is NULL.

       

      Run R script

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hello,

         

        This wouldn't work as the columns would be deleted in the query phase, right?

         

        What I need is a 20-values column that, depending on the data, auto-filters to only either 10, 12 or 15 of those columns, without having blank columns, as it gives unnecesary information and creastes a horizontal scroll I definitely not want.

         

        This feature is a must, but I don't see neither many votes in the Ideas about this issue nor any announcement to include it in following PBI releases.

         

        Regards