Forum Discussion
Super UserConcat strings and indentation in Matrix
Hello everyone!
I need your help to solve a problem. I need to insert two concatenated fields, namely Description and Code, as rows in a Power BI matrix. I would like the Code to be properly aligned as if it were in a separate column from the Description, even though they are actually in the same column.
I've tried different codes, some work in a table, but when dragged into the matrix, they appear misaligned.
Do you have any ideas? Thank you very much.
As-is:
Hi BeaBF,
First of all, you must use a monospace font (Courier New, for example).
Secondly, you must switch off the "Word wrap" option in the "Row headers" setting of the Matrix visual (see this solution - https://community.fabric.microsoft.com/t5/Desktop/Keep-spaces-in-column-fields-when-using-table-matrix/m-p/432210).
Then everything works with a calculated column like this:
And the same in plain text:
LIV_5 = VAR MinIdent = 1 VAR MaxLen = MAXX ( ALL ( data ), LEN ([Description] )) VAR QtyExtraSpaces = MaxLen - LEN ( [Description] ) + MinIdent RETURN [Description] & REPT (UNICHAR(32), QtyExtraSpaces ) & CONVERT ( [Code], STRING )Best Regards,
Alexander
3 Replies
- barritown
Solution Sage
Hi BeaBF,
First of all, you must use a monospace font (Courier New, for example).
Secondly, you must switch off the "Word wrap" option in the "Row headers" setting of the Matrix visual (see this solution - https://community.fabric.microsoft.com/t5/Desktop/Keep-spaces-in-column-fields-when-using-table-matrix/m-p/432210).
Then everything works with a calculated column like this:
And the same in plain text:
LIV_5 = VAR MinIdent = 1 VAR MaxLen = MAXX ( ALL ( data ), LEN ([Description] )) VAR QtyExtraSpaces = MaxLen - LEN ( [Description] ) + MinIdent RETURN [Description] & REPT (UNICHAR(32), QtyExtraSpaces ) & CONVERT ( [Code], STRING )Best Regards,
Alexander
- BeaBF
Hi barritown!
First of all, thank you very much for your help. It's just what I had already implemented, with a slightly different formula but returning the same output.I realized from your answer that the problem is the font, but I have a mandatory font to use.
Do you know if there is any resolution for this problem?
