Forum Discussion
PaulDenne
Helper I
Helper IMatrix 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...
GilbertQ
Super User
Super UserHi 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
PaulDenneHelper I
Helper Ithanks will try to have a look at that later today