Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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?
| User | Count |
|---|---|
| 52 | |
| 35 | |
| 22 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 69 | |
| 57 | |
| 39 | |
| 21 | |
| 21 |