Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
HI,
I have a table like the following:
ID | CARACT | VALUE |
a1 | caract1 | value1 |
a1 | caract2 | value2 |
a2 | caract1 | value3 |
a2 | caract2 | value4 |
I would like to transform it into:
ID | caract1 | caract2 |
a1 | value1 | value2 |
a2 | value3 | value4 |
I mean, the ID column would look exactly the same, but the column carac is replaced by the columns that used to be the rows, obtaining the values of the column value.
I tried to transpose but I also transposed the ID column and they appear wrong.
How can I do this transormation?
Thank you very much.
Solved! Go to Solution.
Hi @silvias ,
Go to PowerQuery, select the column Caract and choose Pivot Column.
Select Value as values column and in the advanced options choose Don't aggregate.
If I answered your question, please mark it as a solution to help other members find it more quickly.
Hi @silvias ,
Go to PowerQuery, select the column Caract and choose Pivot Column.
Select Value as values column and in the advanced options choose Don't aggregate.
If I answered your question, please mark it as a solution to help other members find it more quickly.
@silvias try this
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSjRU0lFKTixKTC4BscoSc0pTDZVidVBkjGAyRhAZI0w9xugycD0mSrGxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, CARACT = _t, VALUE = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", type text}, {"CARACT", type text}, {"VALUE", type text}}),
#"Pivoted Column" = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[CARACT]), "CARACT", "VALUE")
in
#"Pivoted Column"
@silvias In PowerQuery select column 'CARACT' and choose 'Pivot Column' on Transform Tab.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
67 | |
61 | |
52 | |
36 | |
36 |
User | Count |
---|---|
84 | |
74 | |
56 | |
45 | |
44 |