Hi there, I have a created a dashboard linked to Service cloud cases. When i hover over the bar i would like a list of the case subjects to appear in the tool tip, but currently I can only show "first subject", would there be a way to concatenate the subjects when there is more than 1 case in that section?
Thanks you!
Liam
You can use an expression like this to concatenate all the text values together.
NewMeasure = CONCATENATEX(VALUES(Table[Column]), Table[Column], ", ")
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi, there, the subjects are different rows, so would I just ave to concatenate one column?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
189 | |
69 | |
66 | |
60 | |
55 |
User | Count |
---|---|
194 | |
103 | |
90 | |
81 | |
74 |