text box
1 Topic
Concat 2 columns for every row of a report in a dynamic textbox?
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!Solved1.2KViews0likes4Comments