Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
TheBIGuy_PBI
Helper II
Helper II

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

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

This is my original table

TheBIGuy_PBI_2-1681237538775.png____________________________________________________________________________________________________________________________


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.


TheBIGuy_PBI_3-1681237660278.png


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.

 

TheBIGuy_PBI_4-1681238667951.png

_________________________________________________________________________________________________________________________________________

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

 

Thanks, Steve





 

1 ACCEPTED SOLUTION
DOLEARY85
Super User
Super User

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])

 

DOLEARY85_0-1681243680137.png

 

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 👍

 

View solution in original post

3 REPLIES 3
TheBIGuy_PBI
Helper II
Helper II

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
Super User
Super User

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
DOLEARY85
Super User
Super User

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])

 

DOLEARY85_0-1681243680137.png

 

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 👍

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.