How to display in the report only those columns from a table that are populated with some data

[marypal]

Hello,

I have a table [Table] that contains columns: id, col_a, col_b, col_c, col_d, col_e.

A slicer allows me to display values for a particular month.
I need do display only those columns that contain any data.

Fo example, in Feb-23 columns col_c and col_e do not contain any data, so the report should display only columns col_a, col_b, col_d.
In Mar-23 the column col_b does not contain any data, so the report should display only columns col_a, col_c, col_d, col_e.
Could you please tell me if this can be implemented in Power BI, considering that DirectQuery mode is used??

Many thanks

[Anonymous · Accepted solution]

Hi @marypal ,

As far as I know, there is no formula that automatically hides blank columns.

Power BI is now unable to achieve what you need . You can vote here: Auto-Hide Blank Visual table columns .

If I have misunderstood your meaning, please provide more details.

Best Regards
Community Support Team _ Rongtie

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