Remove a column from Table visual when data for all years displayed are blank

[Anonymous]

Hi PowerBi Community,

I have a table visualization that looks similar to this:

Year	Column 1	Column 2	Column 3	Column 4
2015	10	5	0	0
2016	10	5	1	0
2017	10	5	2	0

The years are dynamic and filtered via  slicer - so this table might be expanded to show data from 2009-2019, etc.

My question is that if all values are blank or 0, then I do not want that column to be displayed in a visual. So the expected results for the above example would be:

Year	Column 1	Column 2	Column 3
2015	10	5	0
2016	10	5	1
2017	10	5	2

Can anyone point me in the correct direction for how this could be handled?

Thank you!

[pjjfmarques]

HI @Anonymous,

You can't hide a column from a table view that you specifically indicated to be present.

Se other possible workarounds in the following post:

https://community.powerbi.com/t5/Desktop/How-can-i-hide-Column-measure-in-a-Table/td-p/32400