Forum Discussion
Transposing from columns to rows
Thank you Pete, that has worked for and saved me a lot of time.
I don't know what I have done, but done a fresh one and just cannot group it, I wont give me the 2nd column in the grouping
Help!
Michelle.
- BA_Pete3 years agoSuper User
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
- michellerob20003 years agoHelper I
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
- BA_Pete3 years agoSuper User
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