Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Can I literally hide,but not delete, columns in a matrix? It is just like hiding columns in Excel, but doesn't allow users to unhide them.
I have found a wordaround solution for the question (Solved: Hiding a column in Matrix but not in total - Microsoft Power BI Community), but doing it this way yields some drawbacks as shown in my illustrations.
1. Users can "unhide" the hidden columns by manually adjusting the widths of the hidden columns
2. The matrix has some weird spacing between columns as circled in red(rendered by the small width of the idden columns)
Hence, is there any ways for developers to really hide the columns of a matrix such that users cannot "unhide" them and no weird spacings between columns are shown?
I need to do that because of DAX issues and I have to keep those columns yet don't want users to see them for clarity / formatting requirement.
Before "hiding":
After "hiding":
I realized there are no responses for some days.
Is it right that, it is impossible to hide columns and partially change the font of "row" in a matrix?
But even if so, how to? The quarter column I shown is in "Rows" section, and it seems to me that the font settings of "Rows" are global: I cannot just change the font of column "Quarter".
And in my another report, the column year is an issue too, because year is a 4-digit number and not being able to adjust the font size, makes the width of the total row become unnecessarily wide.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
56 | |
56 | |
38 | |
29 |
User | Count |
---|---|
75 | |
62 | |
45 | |
40 | |
39 |