topic Re: Concat strings and indentation in Matrix in DAX Commands and Tips

Concat strings and indentation in Matrix

BeaBF — Fri, 26 May 2023 07:07:50 GMT

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:

Re: Concat strings and indentation in Matrix

barritown — Fri, 26 May 2023 09:59:20 GMT

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

My YouTube vlog in English

My YouTube vlog in Russian

Re: Concat strings and indentation in Matrix

BeaBF — Fri, 26 May 2023 10:29:30 GMT

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?

Re: Concat strings and indentation in Matrix

barritown — Fri, 26 May 2023 12:49:31 GMT

Hi BeaBF,

Unfortunately, without a monospace font the problem seems to me unsolvable. I hoped to solve it with the help of the tabulation symbol instead of extra spaces but it doesn't work.