Forum Discussion
Change Sequenced data to Columns
Hey All. I have a PowerBI model that has a table that contains Ids of applications, platform and the platform sequence. The platform sequence refers to which platform the app will migrate to over tim...
Hi bblackwell3,
Transpose is not required in your case. Go to Power Query and Pivot the Platform Sequence column and in the dialogue box, select Platform as Value Column.
Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI
Thanks Shaurya . That did get me one step closer but..
However, I need for the App ID to only appear one time and 1, 2, 3 and 4 should be populated with the Platform Name. Like the below
The pivot parameters should be the ones as shown in the image below.
Make sure the Platform Sequence column is selected first before you click the Pivot Column button.
I have also attached the PowerBI workspace
