Forum Discussion

darynv_za's avatar
darynv_za
Icon for Advocate I rankAdvocate I
9 years ago
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...
Need Help
  • robofski's avatar
    robofski
    9 years ago

    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.

robofski's avatar
robofski
Icon for Resolver II rankResolver II
9 years ago

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

darynv_za's avatar
darynv_za
Icon for Advocate I rankAdvocate I
9 years ago

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.