Removing Columns if they have no Values

[Anonymous]

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 · Accepted solution]

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]

Uncheck this guy in your visualization pane

[Anonymous]

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