In Power BI desktop, I have a table that basically looks like this, which I download using an API.
From that, I want to create a table that looks like this, so that I can use it to populate the Sankey visual. There will be more metrics on it than this, but this will work as an example for my frustration. lol
The first two columns would never change. The third column would need to be based off the other table.
Currently I am manually doing this in Excel, and importing that table, but that isn't ideal.
I thought I might be able to just Enter Data as a Data Source in Power BI and somehow use a formula to point to the other table, but that was a no go. Does anyone have any suggestions on how I can make this happen?? Any help would be greatly appreciated.
Helpful resources
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
