Forum Discussion
Helper IIMatrix 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
devesh_guptaImpactful Individual
Check Data Availability for Row C
- Verify whether C has data for the filters applied to the second matrix.
- 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.
AC23VMI 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
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:
If you find this insightful, please provide a Kudo and accept this as a solution.
- AC23VM
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
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!