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 Anonymous
If that is a dimension and a number, create another column that returns a no width space repeated by the number in that dimension. For example:
REPT ( UNICHAR ( 8203 ), 'table'[your column] )
Rename the column for the visual to a space and reduce the width. If the width of the column headers are set to auto, the calculated column will still occupy a very small space as its values have no width.
Another alternative is to conditionally format the text color to transparent uising a measure
Transparent =
"RGBA ( 0, 0, 0, 0 )"
. The column values in the image below are transparent. The column name in the visual renamed to a space.