Line Break integrate in current measure

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 | Power BI | Data Analytics

 

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.