Forum Discussion

jatneerjat's avatar
jatneerjat
Icon for Helper V rankHelper 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
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft 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