topic Re: Removing Columns if they have no Values in DAX Commands and Tips

Removing Columns if they have no Values

Anonymous — Mon, 07 Mar 2022 15:35:17 GMT

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?

Re: Removing Columns if they have no Values

Syk — Mon, 07 Mar 2022 15:42:09 GMT

Uncheck this guy in your visualization pane

Re: Removing Columns if they have no Values

Anonymous — Mon, 07 Mar 2022 16:49:14 GMT

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

Re: Removing Columns if they have no Values

v-jingzhang — Thu, 10 Mar 2022 02:32:30 GMT

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.