Forum Discussion

jatneerjat's avatar
jatneerjat
Helper V
7 years ago

Remove Null columns from a table

Hi 

 

How can I remove a column which have null values from a table.

Both rows and columns coming from two different measures.

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Go to Data model.

    Rigt Click column

    Delete

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi jatneerjat ,

     

    Is the screenshot a Table visual or Matrix visual? 

     

    If it is a Table visual, now that that column or measure returns empty value, why not directly remove it from visual?

     

    If it is a Matrix visual, you could apply "Visual Level Filters" to filter out empty records.

     

    For more advice, please provide dummy data and necessary mesure formulas you used. How to Get Your Question Answered Quickly

     

    Regards,

    Yuliana Gu