Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. 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?
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 53 | |
| 39 | |
| 35 | |
| 19 | |
| 18 |
| User | Count |
|---|---|
| 73 | |
| 73 | |
| 38 | |
| 35 | |
| 26 |