Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Anonymous
Not applicable

Carriage return values in matrix

Hi,

 Is there any option in matrix that values to be carriage return. for example: I have values like below :

Note: i want it in single cell not into multiple rows.

From:

A,B,C

 To:

A
B
C

 

The above i can able to do in edit queries section but when i click "close and apply". The column which i have formatted like above is not coming. Values are  automatically displayed in single line. 

Output:

I want to see in "DATA" section as below:

A,B,CA
B
C
C,D,EC
D
E
E,G,HE
G
H
H,I,KH
I
K

 

 

Thanks,

Prasanth.C

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@Anonymous ,

 

Based on my test, I'm afraid the data view doesn't suppot multiple lines in a cell. 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yuta-msft
Community Support
Community Support

@Anonymous ,

 

Based on my test, I'm afraid the data view doesn't suppot multiple lines in a cell. 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.