Forum Discussion
Tabular table in Power BI
I need to make a matrix consiting of a number of dimensions on rows and a dimension in the columns but the matrix visual only displays one level at any given time. Instead I need to drill up and down.
Generally, the columns and rows in matrix are collapsed by default, we can only see one level data. If you want to see all levels data, please click "Expand all donw one level in the hierarchy" button. And set "Stepped layout" option off.
Regards,
Charlie Liao
I need to make a matrix consiting of a number of dimensions on rows and a dimension in the columns but the matrix visual only displays one level at any given time. Instead I need to drill up and down.
Generally, the columns and rows in matrix are collapsed by default, we can only see one level data. If you want to see all levels data, please click "Expand all donw one level in the hierarchy" button. And set "Stepped layout" option off.
Regards,
Charlie Liao
OK,
Indeed, that does work, but here's a situation we have and it looks to me like Power BI doesn't do this. In an excel pivot table, you can select which rows to display in Tabular format such that in the fully collapsed mode you can see the Project name and its overall health status, then open the other layers and they display in the heirarcial manner. This appears to be an "all-or-nothing" solution, i.e.) there isn't a way to select specific rows to turn the stepped layout off on?
Did you eventually get an answer?
Great job, thank you v-caliao-msft Kvilk
