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.

v-venuppu's avatar
v-venuppu
Community Support
1 year ago

Hi micdwo ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you rohit1991 burakkaragoz for the prompt response.

 

I have created a sample PBIX file by using sample data to replicate the scenario.Please go through the attached PBIX file for your reference.

Thank you.