Forum Discussion
teng1
3 years agoFrequent Visitor
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 t...
Kishore_KVN
3 years agoSolution Sage
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
3 years agoFrequent Visitor
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_KVN3 years agoSolution Sage
Yes teng1 , you are using it almost right. Can you please share the screenshot of output that you are getting
- teng13 years agoFrequent Visitor
sure,
- Kishore_KVN3 years agoSolution Sage
So the values in the Matrix visual are not right?