Power BI - headers to lines and sum the values of them (Like summary the values of columns)

[Olvrapha]

Hello everyone!

I'm a beginner on Power BI and i need some help, please.

I'm making a report on Power Bi with the answers of my survey about investments, some of asks have multiple choices and that choices are transformed into column... so, how can i do a unique column with this multiple choices of each participant? is it possible to do this?

Obs. The multiple choices are columns ("33.25.1", "33.25.2",...,) and the answers is "1" in lines.

Asks are Columns and answers are linesIf i put in "Categoria" appears "(Em Branco)"

[mlsx4]

That's nice @Olvrapha !!

Don't forget to mark it as solved. It could be useful for other users.

[mlsx4 · Accepted solution]

Hi @Olvrapha 

I will do the following:

• First, duplicate the values and get only the ID of the answer, and the columns related to the multiple choice option. Like this

• Then, unpivot the column:

• Replace the values 1, 2, 3...by the real answer and relate the second table with the original one by ID

Not sure if this helps, but it may work

[Olvrapha]

It worked! Thank you very much!! 💖