Pivot - can it be

[darynv_za]

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.

[robofski]

Have you looked at the Matrix visual that should give you what you need.

[darynv_za]

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.

[robofski]

Is this not the kind of thing you are trying to produce?

[darynv_za]

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

[robofski · Accepted solution]

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.

[darynv_za]

Many thanks kind sir, seems I missed that one 🙂