Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |