matrix column title in 2 rows error

[teng1]

Hi All,

I am having this weird issue where when i click on the content in the matrix report, power bi desktop will prompt me error message of :

In the matrix, i am required to display the column title in two rows. So, i created a reference table where in a column, i split the column title accordingly.

sample value from the reference table:

The above error only happen when i use the value on the left column (2 rows version) as the matrix column title.

Is there hidden characters like carriage return or line break at the end of first line, which caused the error above?
Any suggestions how could i solve this problem?

Regards,

[Kishore_KVN]

Hello @teng1 instead of creating another table, create a new column in the same table and use UNICHAR(10) to break the like and then use that column in the Matrix Visual.

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

[teng1]

hi @Kishore_KVN 

Thanks for the suggestions. I tried that with following formula in the new column, but i still got the same error message. Am i doing it correctly?

[Kishore_KVN]

Yes @teng1 , you are using it almost right. Can you please share the screenshot of output that you are getting 

[teng1]

sure,

[Kishore_KVN]

So the values in the Matrix visual are not right?

[teng1]

The values in the matrix visual are correct. Display in 2 rows.
Are you saying that the output of the new column formula is in 1 row but the visual displayed in 2 rows?