Forum Discussion
How to hide column in matrix visual in PBI Desktop
- Anonymous1 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.
Hi,
Rename that measure to make it of a very short length. Turn off wrap text for that header. Reduce the width of that column to 0.