Hiding Columns in table

[Anonymous]

Hi PBI users,

I have a table which contents blanks columns based on the filter. 

When T= 2019

2019	x	y	z
a	0
b	0
c	0

When T=2020

2020	x	y	z
a		0
b		0
c		0

I want to hide the blank columns based on T, so my desire result will be

When T= 2019

2019	x
a	0
b	0
c	0

When T=2020

2020	y
a	0
b	0
c	0

Is there a way to hide blank columns?

Thank you

Best, Qianru

[V-lianl-msft · Accepted solution]

Hi @Anonymous

If you want to hide empty columns on the table visual, I haven't found a solution yet. You could submit your idea to help improve power bi. What I understand is that there are constraints between the contents of each row in a table. You can't hide a column without hiding the corresponding row.

Best Regards,

Liang 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.