Forum Discussion
Transposing from columns to rows
I need to move the names (col B) to rows assigned to the app group name - I've tried unpivot - I cannot work out how to do it. For example WP2CCAC - Kasia Barnert and Shelley Attfield on one row...
Hi Michelle,
Not sure what the question is here.
If you select your [App Group Name] column, go to the Home tab > Group By, then add a SUM aggregated column on your [description] column that should get you back to where you can swap out the code as before.
Pete
In the group by, it is not letting me click on the drop own for the sum and on the column dropdown it wont open up for me to select Description column
Make sure that the Group By dialog box is in the centre of your PowerBI app window, not on the edge of it or just outside of it.
If this isn't the issue, then you may need to send screenshots/gifs of what's happening.
Pete