Forum Discussion

Unknowncharacte's avatar
Unknowncharacte
Helper III
2 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    2 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: 

    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.