expandcolumns
2 TopicsPowerBI matrix show rowlevels dynamically
Hello, I am using a tablematrix in PowerBI with 6 rows and 7 values. I present this in the matrix with a Stepped layout. See the first example. As you can see, there are 5 levels to expand to. Basicly there are 6 but in this example, I show only 5. As you can see in the second example, on level 5 (and 6) is the row empty except for the 6th and 7th column. Is there a possibility within PowerBI to hide this level 5 blank row and show only the subtotals? So when expanding to a next level, show only if there is information on row level. Otherwise, show only the subtotals but in combination with rows that contain information.614Views0likes0CommentsExpandRecordColumn versus ExpandListColumn
Problem: when expanding a JSON dataset, programmatically, you can expand a list of Tables using Table.ExpandListColumn, specifying only the column name to be expanded, which is fine. But if you want to expand a list of Records, you seem to have to specify the column names manually. It would be preferable, to have a more generic, less fragile, solution, that would allow you request all columns, without needing to name them, or at least to use a function that could return those column names, before expansion, so to speak. Is this possible?Solved7.5KViews1like3Comments