Forum Discussion
Solved
hide second column in matrix
Is there any way to hide columns for below layout in matrix? For Subname3 I would like to display data however for others (Subname1, Subname2) to hide them because they are blank. Similarly applies...
Hi micdwo ,
To hide the Column2 Display in the matrix only for specific Subname values (e.g., when Subname "not equal to" Subname3), Power BI doesn’t support dynamic column removal. However here are few workarounds that will help:
Use a measure that returns BLANK() when Subname "not equal to" Subname3 to hide values.Apply conditional formatting to make the column appear invisible (e.g., white font/background).Use slicers or bookmarks to toggle matrix visuals based on Subname.Create separate matrix visuals for different Subname values if needed.
Thank you.
