Forum Discussion
Matrix and Zero Columns
Hi all I have looked at previous posts about hiding /filtering out Zero columns in a Matrix they all seem to suggest having a measure and the applying a filter to that but my Matrix has appr...
just tested, makes table easier to read removing all the Zeros but does not hide column from view if all blank still, INC3 and INC4 would still show but the zero are blanks
hope was to hide the unused columns as depending on slider selection, could be 30 + not needed making the table very unnecessarily wide
Hi PaulDenne
The reason the values still show is because the measure is put into the table/matrix.
A workaround is that you need to use disconnected table measure, which should allow use a table for the values and if there are no values then it should not display.
Calculation Groups with Disconnected Tables in Power BI/AAS - FourMoo | Power BI | Data Analytics
thanks will try to have a look at that later today