Line Break integrate in current measure

[Unknowncharacte]

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 able to solve this but I cannot seem to integrate it into the current measure. Would someone please help?

Desired Outcome

Sample Data:

Line Break.pbix

Current Quick Measure:

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],

            ", ",

            'Subjects'[Job Title],

            ASC

        )

    )

[Anonymous · Accepted solution]

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: 

DAX – How to get a line break in a DAX measure for Labels or Titles in a Power BI report? - FourMoo ...

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.           

[Unknowncharacte]

Thank you, I was tacking it on in completely wrong places 😬

[speedramps]

[Unknowncharacte]

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 #

[speedramps]

Why  is A12 followed by a blank? A12 does not have CEO is either table!

[Unknowncharacte]

where do you see this?