Forum Discussion

teng1's avatar
teng1
Frequent Visitor
3 years ago

matrix column title in 2 rows error

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,

Need Help

6 Replies

  • Kishore_KVN's avatar
    Kishore_KVN
    Solution Sage
    3 years ago

    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's avatar
      teng1
      Frequent Visitor
      3 years ago

      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's avatar
        Kishore_KVN
        Solution Sage
        3 years ago

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