Concat 2 columns for every row of a report in a dynamic textbox?

[jthajek]

Good Morning,

I am relatively new to PowerBI and still learning so this may be a simple answer that I just haven't been able to piece together from the information that's out there.

I have a report that has a Measure to average values from a database (Column2) that share a common Description (Column1).

This gives me a report with a number of rows based on the unique Descriptions in the database.

I would like to have a text box that concatenates the Text in Column1 and the value in Column2 on its own line for every row in the report.

I've tried to reference the values in a text box, but it only returns the most recent value in the whole database, not the report, and it only gives me one line, not a line for every row.

PowerBI seems like a powerful program, and I'm excited to learn more about it, so any help would be greatly appreciated!

[tamerj1]

Hi @jthajek 
Please try

Concat =
CONCATENATEX (
    VALUES ( 'Table'[Description] ),
    'Table'[Description] & " - " & [Measure],
    UNICHAR ( 10 )
)

[jthajek]

Thank you for your swift reply, it's giving an error "Cannot find table 'Table'."

Do I need to reference my report in a table or does it somehow do that automatically?

So I realized I needed to pass the datatable as the "Table", now I get an unsorted list with the values! 

Is there a way to sort the list and limit the number of decimal places?

Thank you so much for your help!

I figured out that using a Round function fixed the decimal places issue.

[tamerj1 · Accepted solution]

@jthajek 

To obtain a sorted list 

Concat =
CONCATENATEX (
VALUES ( 'Table'[Description] ),
'Table'[Description] & " - " & ROUND ( [Measure], 0 ),
UNICHAR ( 10 ),
'Table'[Description], ASC
)

[jthajek]

You're amazing! Thank you so much for your help, that worked perfectly!