Forum Discussion
Unknowncharacte
Helper III
2 years agoLine Break integrate in current measure
Hello, I created a list of job titles using quick measure(List of Job Title Values), however, I need it to do a line break after each concatenation, how do I do that? I found unichar(10) might be ab...
- Anonymous2 years ago
Hi Unknowncharacte ,
List of Job Title values = VAR __DISTINCT_VALUES_COUNT = DISTINCTCOUNT('Subjects'[Job Title]) VAR __MAX_VALUES_TO_SHOW = 10 RETURN IF( __DISTINCT_VALUES_COUNT > __MAX_VALUES_TO_SHOW, CONCATENATE( CONCATENATEX( TOPN( __MAX_VALUES_TO_SHOW, VALUES('Subjects'[Job Title]), 'Subjects'[Job Title], ASC ), 'Subjects'[Job Title], ", ", 'Subjects'[Job Title], ASC ), ", etc." ), CONCATENATEX( VALUES('Subjects'[Job Title]), 'Subjects'[Job Title], ", "&UNICHAR ( 10 ), 'Subjects'[Job Title], ASC ) )As shown above what I did was to put in the UNICHAR ( 10 ) which would then put each item on a new line.
Below is what it looks like.
Reference:
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
2 years agoNot applicable
Hi Unknowncharacte ,
List of Job Title values =
VAR __DISTINCT_VALUES_COUNT = DISTINCTCOUNT('Subjects'[Job Title])
VAR __MAX_VALUES_TO_SHOW = 10
RETURN
IF(
__DISTINCT_VALUES_COUNT > __MAX_VALUES_TO_SHOW,
CONCATENATE(
CONCATENATEX(
TOPN(
__MAX_VALUES_TO_SHOW,
VALUES('Subjects'[Job Title]),
'Subjects'[Job Title],
ASC
),
'Subjects'[Job Title],
", ",
'Subjects'[Job Title],
ASC
),
", etc."
),
CONCATENATEX(
VALUES('Subjects'[Job Title]),
'Subjects'[Job Title],
", "&UNICHAR ( 10 ),
'Subjects'[Job Title],
ASC
)
)
As shown above what I did was to put in the UNICHAR ( 10 ) which would then put each item on a new line.
Below is what it looks like.
Reference:
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Unknowncharacte2 years ago
Helper III
Thank you, I was tacking it on in completely wrong places 😬