Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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" } ]
Solved! Go to 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
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:
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |