topic Re: Concat 2 columns for every row of a report in a dynamic textbox? in DAX Commands and Tips

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

Anonymous — Tue, 06 Jun 2023 13:08:00 GMT

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!

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

tamerj1 — Tue, 06 Jun 2023 14:09:20 GMT

Hi Anonymous
Please try

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

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

Anonymous — Tue, 06 Jun 2023 16:01:28 GMT

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.

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

tamerj1 — Tue, 06 Jun 2023 17:43:43 GMT

Anonymous

To obtain a sorted list

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

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

Anonymous — Tue, 06 Jun 2023 17:47:20 GMT

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