Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

How to hide column in matrix visual in PBI Desktop

PBi Desktop Version 2.146.1026.0 64-bit (August 2025)    I would like to hide 1 column named PlanNo on MATRIX VISUAL in PBI desktop. How do I achieve this.   What I have already tried   1 Used ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

     

    I understand your concern. At the moment, Power BI does not provide a direct option to hide a column inside a Matrix while still keeping it in the visual. If the column is placed in the Matrix, it will always try to render. The trick of dragging the width to zero or renaming the column only hides it cosmetically and, as you noticed, disturbs the header alignment.

     

    The cleaner workarounds are either to replace the column with a measure that returns Black() so it looks hidden but can still be used for your dependent calculations in the model), or to apply conditional formatting that makes the values transparent and rename the header to a space to keep the layout intact. Apart from these, there isn’t a native setting to fully hide such a column without removing it.

     

    Thank you,

    Tejaswi.