topic Help - Transform Nested table in Custom Visuals Development Discussion

Help - Transform Nested table

Anonymous — Sun, 16 Jan 2022 12:55:49 GMT

Hello all,

I'm quite new with Power BI and searching for help in convert a nested table.
The aim is to create a new table from the nested table records.
Collum-1 records should be the headers from the new table columns and the column-2 records should be the records to fulfill the new rows under the new columns.

Sample:

Converting the Nested Table bellow

Into the new table like this

What should I do it?

Pink.dutch

Re: Help - Transform Nested table

AlexisOlson — Sun, 16 Jan 2022 19:06:49 GMT

It looks to me like you can pivot the field.name column using Parameter Value as your values column.

Re: Help - Transform Nested table

Anonymous — Tue, 18 Jan 2022 08:05:22 GMT

Thanks @AlexisOlson it works. just having another challenge in regards multi-language, managing.