Trying to combine text from multiple fields in a row in a table, into one row

[TheBIGuy_PBI]

Hi, I'm trying to combine multiple fields from a table into a single record, for each question

This is my original table

____________________________________________________________________________________________________________________________

My goal is to turn this into two single lines with a carriage return between the specific fields.

This is what I'm trying to figure out how to do, below.

I'm doing this because in my Stacked Bar Chart, I need a tooltip pop up that not just shows the single
ANSWERTEXT/TOTAL RESP/PERCENT/QUESTIONTOTAL
as a one row popup, but to show all the possible Answers in one pop up.  I think with the data combined and the <NewLine> Carriage returns, I can show every Answer to each question in one pop up.
_________________________________________________________________________________________________________________________________________
In the example that I'm trying to modify below, you see one answer on one line, when you hover over the bar.  The goal is to show multiple lines for each popup per question no matter which bar on the question I hover the mouse over.

_________________________________________________________________________________________________________________________________________

Any help is really appreciated.  And happy to provide additional info.

Thanks, Steve

[TheBIGuy_PBI]

Thanks, up to this point this is a solution.
ConcatenateX is pretty good for combining different fields into one row but the challenge i have is how to only combine the text grouping them by the question.

I put another question out there for this part. Once I get that done, my problem will have been solved.

[Ashish_Mathur]

Hi,

Share data in a format the can be pasted in an MS Excel file.

[DOLEARY85 · Accepted solution]

Hi,

it's not quite there yet but i thought i'd provide a start:

Power query custom column:

  [Question] & " " & [Answer] & Character.FromNumber(10) & Number.ToText([response]) & " "& Number.ToText([percent]) &" " & Number.ToText([total])

just need to find a way to bring duplicate question rows together and then remove the name of the question from the 2nd row.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍