topic Re: Hide columns/rows in matrix if no data in DAX Commands and Tips

Hide columns/rows in matrix if no data

Anonymous97 — Tue, 06 Dec 2022 11:19:48 GMT

Hello All,

I have requirement where we should not show the empty columns if no data available. Below is my requirement

In matrix visualization

Rows field- Id

Column- time series

Values -measure 1 and measure 2

Based on timeseries if measure 1 column is empty then we should hide entire timeseries column (marked in yellow)

even though we have values in measure 2 column.

Please find the below screeshot.

Unfortunately i cannot share the sample file.

Any help appreciated.

Thanks in advance

Re: Hide columns/rows in matrix if no data

Anonymous — Wed, 07 Dec 2022 02:00:48 GMT

Hi Anonymous97 ,

Sorry, but if there is no data, the column still exists in the table/matrix.

Power BI may not support this feature for now, hopefully Power Bi will implement this in the near future.

If you also want this in power bi, let the power bi community to know this things and give your votes at power bi site's feedback.

Microsoft Idea (powerbi.com)

OR:

You can define the size of the column so you can hide then until is invisible just drag the border of the column, be aware that you may need to turn off text wrap on the options on column headers.

Best Regards,

Liu Yang

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

Re: Hide columns/rows in matrix if no data

TimoRiikonen — Fri, 24 Nov 2023 09:09:44 GMT

Note this hiding answer doesn't work.
Both with tables and matrix, if you hide column when it doesn't have a value (or when it has a value), it doesn't appear back when it has a value. These graphs can only hide empty rows and not empty columns (besides the header).