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.
