Forum Discussion
Solved
Remove Secondary columns in Matrix Visual
I have a matrix where each column has two values - how do I remove the S_puts values from only the L_P1 columns? The column of data which I pull from is blank (and will always be blank) for any line ...
Hi jonny2615
That is the expected behaviour - you cannot dynamically hide a measure column when its value is blank. The workaround is to use a disconnected table containing the measure name and reference this disconnected table in a measure. Notice that in the image below, Latin America doesnt have a column for revenue
Please see the attached pbix.
Simply drag the column border to the left for the speficif column you dont want to see in your visual and disable auto-size column width from the visual settings so that the visual would stay as same.