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?
@johnyip , Make both text and background color same and then make with 0, even if the user change width they will not be able to see anything
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.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
125 | |
78 | |
69 | |
54 | |
53 |
User | Count |
---|---|
191 | |
104 | |
83 | |
79 | |
78 |