Forum Discussion
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 having to take my dataset out of the system, then dumping it into Excel to create a simple thing like a pivot where we can control the rows, columns and grouping? I have a dataset with incidents in a call logging system and need to report on per day, by support group as well as the person in the group under that. Right now I can concatenate the Group and person to get SORT OF what I need, but this is not pretty as the alignment is completely out.
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.
6 Replies
Have you looked at the Matrix visual that should give you what you need.
I have tried this, unfortunately when you have more than one item in the Rows attribute, it does not create a step down (like I am sure it used to) but forces you do drill down. I would like to be able to see the support team, and then each staff member under that at a quick glance.
Is this not the kind of thing you are trying to produce?
