Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I have tried to Google around for answers but do not seem to find what I am looking for.
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.
In PowerPivot you can change the layout to "show item labels in tabular form".
Does anyone know if this is possible to PowerBI?
Solved! Go to Solution.
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
Hi, This is very useful. I have a quick questions, based on the example above, how can i make the AAA appear in every line?
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |