Forum Discussion

micdwo's avatar
micdwo
Regular Visitor
1 year ago
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...
Need Help
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    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.

micdwo's avatar
micdwo
Regular Visitor
1 year ago

I enclose screenshot for better presentation of desired layout

1. Show items with no data - I keep it turned off as below however nothing changed

 

2. For column 2 'Subname3' has values, other Subnames have them blank (no space, null, N/A etc.)

3. DAX Measure as suggested with ISBLANK replaced in 'Values' however matrix displays then only one column (either column 1 which is ok OR column 2 only for Subtype3), not sure how to display ALL values from column 1 and conditionally only Column2 for Subtype3.

 

Thank you in advance.