Forum Discussion
Hide columns/rows in matrix if no data
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.
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.
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.
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.
Advocate VNote 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).