Good Day. I have no idea how to generate a matrix view with Grouped items on the Row well. Please check the attached screenshot and it shows the way I wanted to group the items. Please help me how to do it in Power BI Desktop.
Note: I tried to use the "New Group option" and grouped some of the items. But, when I used that into my matrix table, it didn't showed me with the expanded group view, I mean the child items associated to a parent were not displayed. All I got was only the Parent items on the Matrix Row well. Any help will be much appreciated.
The grouping has no effect on the rows, and you can consider that a measure will be calculated as if all columns were populated in a table. If you're looking to do a different calculation depending on hierarchy level, you'll want to use a switch based on ISINSCOPE.
Hi , Grouping works perfectly fine, but I wanted to sort the "parent" column in a particular order. So, I created supporting table with ranking and pulled the respective column from the newly created table into the matrix. Now smth went wrong and grouping does not work any more. I cant figure out why.. puzzled. If any one could help!
I'm having two tables from which I have created the above Matrix visuals but the requirment is that the fields are not coming in +- (expand/shrink) at Row Level, also I have turned on Values"Show on Rows" . Please note my Values are in seperate measure so that can not be moved to Row level Best Regards Manik Nag