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

marypal — Fri, 08 Sep 2023 13:04:18 GMT

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

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

Anonymous — Mon, 11 Sep 2023 02:41:24 GMT

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.

topic Re: How to display in the report only those columns from a table that are populated with some data in DAX Commands and Tips

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

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