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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
AC23VM
Helper I
Helper I

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 I
Helper I

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.

@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
Super User
Super User

@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.

@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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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