Noob needs help with massaging data

[Anonymous]

Hello,

I have following data pulled from webservice. I want to present it as table like below. I was able to get first couple of columns but I'm confused what to do with DataDisk column. I want to output there sum of sizes of each of rows of `datadisk` and when user clicks on that column to show different table with rows for each datadisk.

[
  {
    "DataDisk": [],
    "OSDiskSize": 30,
    "OSDiskTier": "Premium_LRS",
    "name": "greg-win2008"
  },
  {
    "DataDisk": [],
    "OSDiskSize": null,
    "OSDiskTier": null,
    "name": "kt-dev-vm-01"
  },
  {
    "DataDisk": [
      {
        "DataDiskName": "Data",
        "DataDiskSize": 10,
        "DataDiskTier": "Standard_LRS"
      },
      {
        "DataDiskName": "Disk2",
        "DataDiskSize": 10,
        "DataDiskTier": "Standard_LRS"
      }
    ],
    "OSDiskSize": 30,
    "OSDiskTier": "Premium_LRS",
    "name": "Greg-VM"
  },
  {
    "DataDisk": [],
    "OSDiskSize": null,
    "OSDiskTier": null,
    "name": "TEstVM01"
  }
]

[Anonymous]

1. In the "Column1.DataDisk" header, click the expand "dumbells" icon and choose "Expand to new rows"

2. Click the icon again to select the new columns

You should now have this:

[Anonymous]

I figured out how to put sums of all disks into it's own column by using grouping but still uncertain how can I display a different table with details of that column once somebody clicks on it

[v-diye-msft · Accepted solution]

Hi @Anonymous ,

If my understanding is correct, you already got the summary column, but you wanna show the details when click the summary. please kindly check the workround whether works for you: you can use drillthrough to get the detailed data 

https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough 

Best regards,

Dina Ye