Solved: Re: Removing Columns if they have no Values

Anonymous · ‎03-07-2022

Hello,

i have the following dashboard that is working for me perfectly. The one thing I would like to change is the budget schedule table which is the top one. I want it to where if the year is blank then it does not show the the column at all. In this case it would just show 2022-2026. Any workarounds to this?

v-jingzhang · ‎03-09-2022

Hi @Anonymous

If you want to delete Null Columns from data table instead of table visual, you could refer to the following blog:

Dynamically Remove Null Columns in Power Query with M code (antmanbi.com). The steps and explanations are very detailed in it. Hope it is helpful!

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

v-jingzhang · ‎03-09-2022

Hi @Anonymous

If you want to delete Null Columns from data table instead of table visual, you could refer to the following blog:

Dynamically Remove Null Columns in Power Query with M code (antmanbi.com). The steps and explanations are very detailed in it. Hope it is helpful!

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Syk · ‎03-07-2022

Uncheck this guy in your visualization pane

Anonymous · ‎03-07-2022

Okay that works, but is there away to do it if your column is based off values? IE my data looks like this as opposed which would cause me to switch it a whole bunch