Remove Secondary columns in Matrix Visual

[jonny2615]

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 that has L_P1

[cengizhanarslan]

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.

[Ritaf1983]

Hi @jonny2615 

Generally, Power BI does not offer a native "hide column" feature for matrices like Excel; the structure is relatively rigid, similar to a Pivot Table.

However, there are workarounds to influence the structure:

Using Calculation Groups: https://www.youtube.com/watch?v=vMzkX6dHG34

Using a dynamic measure: https://community.fabric.microsoft.com/t5/Desktop/hiding-columns-in-Matrix/m-p/544289

The common factor between these two methods is that a hierarchy must be pre-defined in a side table (disconnected table), combined with a single measure designed to behave according to the specific hierarchy level and column context.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[danextian · Accepted solution]

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.

[ryan_mayu]

@jonny2615  could you pls paste the sample data here and also provide the expected output.