Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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!
Go to Solution.
To obtain a sorted list
Concat =CONCATENATEX (VALUES ( 'Table'[Description] ),'Table'[Description] & " - " & ROUND ( [Measure], 0 ),UNICHAR ( 10 ),'Table'[Description], ASC)
View solution in original post
Hi @jthajek Please try
VALUES ( 'Table'[Description] ),
'Table'[Description] & " - " & [Measure],
UNICHAR ( 10 )
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.
You're amazing! Thank you so much for your help, that worked perfectly!
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.