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...
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