Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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

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
Anonymous
Not applicable

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

 

Anonymous
Not applicable

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

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

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.