cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
artisticcheese Frequent Visitor
Frequent Visitor

Noob needs help with massaging data

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.

 

PBIDesktop_2019-07-22_14-53-00.png

[
  {
    "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"
  }
]

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Noob needs help with massaging data

Hi @artisticcheese ,

 

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

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

3 REPLIES 3
Highlighted
hymieho2 Frequent Visitor
Frequent Visitor

Re: Noob needs help with massaging data

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

1.png

 

2. Click the icon again to select the new columns

 

You should now have this:

2.png

 

artisticcheese Frequent Visitor
Frequent Visitor

Re: Noob needs help with massaging data

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

Community Support Team
Community Support Team

Re: Noob needs help with massaging data

Hi @artisticcheese ,

 

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

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,326)