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

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

    Anonymous,

     

    Actually if you will load R script which will take only not empty columns from your data source and in Power BI M script you will not do any column specific transformation then it will work properly. Let me know if this is not clear.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hello,

       

      I don't know about R, could you share some code so I can start bulding the tabla in R?

       

      Thanks,