Forum Discussion
michellepace
Resolver III
Resolver IIICreate title from concatenated values in table column
Good morning.
Is it possible to write a DAX measure for MyTitle as shown below? That is, how do I get the list of values shown in a table and expand them into a concatenated string?
As always, thank you.
Michelle
michellepace , You can create measure like
concatenatex(Table,[AutoNumber])
and add that to title : https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-format-visual-titles
3 Replies
CNENFRNLCommunity Champion
Hi, michellepace , you may try a measure like this,
Concat = CONCATENATEX ( FILTER ( ALL ( tb[AutoNumber] ), tb[AutoNumber] in {69449, 69458} ), tb[AutoNumber], UNICHAR ( 10 ) )- amitchandak
Super User
michellepace , You can create measure like
concatenatex(Table,[AutoNumber])
and add that to title : https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-format-visual-titles
