Forum Discussion
Solved
Pivot - can it be
Hi Please tell me it's an oversight or that I am just clueless, but the simple option to create an Excel like pivot is missing from PowerBI. I have been tasked with recreating a pivot without hav...
You need to make sure you are using the 'Expand All down one level in the hierarchy' option (3rd icon in on the left) to get the Teams and members.
Is this not the kind of thing you are trying to produce?
Yes, that is what I want to achieve however, I would like to have the date as well as number of tickets in the details. So I would like Date to be a header. below, but as you can see, when doing this I lose the next level
This is what I can do inexcel, and is basically what I need to see