Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
AC23VM
Helper II
Helper II

Matrix not expanding down all levels / missing row?

Hi there.  Hopefully a quick question.  I made 2 almost identical matrices.  Each has 3 rows, with the first row different across matrices - let's say the first matrix has rows A, B, C, and the second matrix on a different page has D, B, C.  When published to the workspace, matrix 1 displays all rows in tiers, A > B > C.  However, matrix 2 seems only to display 2 rows, D > B.  I've expanded down with the dual arrow button, but it seems like it's publishing as if C isn't there.  I've taken C off in Desktop, re-added and r-re-published, but again it's not there.  Bit confused since the first matrix is exactly the same build and works fine.  Anyone know what's going on?

6 REPLIES 6
AC23VM
Helper II
Helper II

I wonder if it's a bug.  I've just copied the matrix onto a new page and re-published, and it works perfectly on that new page.  Exact same filters, nothing added, nothing removed.

devesh_gupta
Impactful Individual
Impactful Individual

@AC23VM That's strange, but good to know that it's working for you after creating a new page.

 

If you find this insightful, please provide a Kudo and accept this as a solution.

Thank You!

devesh_gupta
Impactful Individual
Impactful Individual

@AC23VM 

Check Data Availability for Row C

  1. Verify whether C has data for the filters applied to the second matrix.
  2. If C has no data for the current filter context (e.g., page filters, report-level filters, slicers, etc.), Power BI will not display that row.

If you find this insightful, please provide a Kudo and accept this as a solution.

I don't think there are any filters on.  It displays fine in Desktop, but disappears when published, no more filters are being added.

devesh_gupta
Impactful Individual
Impactful Individual

@AC23VM Can you check if the C category has any data available under the D and B hierarchy? 
Also, try enabling show items with no data from the visualisation pane for the row C:

devesh_gupta_0-1736932907177.png

If you find this insightful, please provide a Kudo and accept this as a solution.

Yes, it has data available.  As I say, it's displaying perfectly in the Desktop.  It's like that row disappears when published.  There are 4 visuals on the page - the other 3 remain identical between Desktop and Workspace.  It's just that matrix that changes.  And again, there's an almost exact copy on another page which isn't changing when published.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.