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.

HarishKM's avatar
HarishKM
Super User
1 year ago

micdwo Hey,
In Power BI Report Builder, you can achieve the dynamic hiding of columns in a matrix by using expressions to control the visibility property of each column. To address the need for displaying only columns with data, follow these steps: 

  1. Set the visibility property of each column based on its content. For example, for columns "Subname1" and "Subname2", use an expression like =IIF(IsNothing(Fields!Subname1.Value), True, False) in the visibility property.
  2. This will hide columns that are blank or have no data. Apply filters at the dataset level to conditionally include only the rows where data exists for certain columns.This ensures that the matrix only processes items with valid data.
  3. Once columns are hidden based on the above conditions, the layout will automatically adjust to fill in gaps where columns are hidden.
  4. This method allows for conditional visibility that reflects the actual data and minimizes clutter by hiding unnecessary columns based on your matrix's data set.

Thanks

Harish KM

If these steps help resolve your issue, your acknowledgment would be greatly appreciated.