Forum Discussion
Unknowncharacte
2 years agoHelper III
Line 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.
speedramps
2 years agoSuper User
Unknowncharacte
2 years agoHelper III
From this
To this
I appologize, I do not know what you mean, there is no blank after A12, CEO is in A13
Titles are all in one cell, separated by a line break and corresponding to the case #