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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.