Forum Discussion
Remove Secondary columns in Matrix Visual
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.
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