Matrix word wrap

[cambell]

Hi,

I've found quite a few posts about people struggling with this and they haven't really helped! I have the word wrap slider option set to on under the row header selector but that doesnt seem to be doing anything?

Also is it possible to word wrap column headers?

Thanks 

Cambel

[Anonymous]

Hello,

I am having trouble to word wrap column Names for Inforiver Matrix visual. I have tried auto wrap column width but it doesn work for column name but for row.

Has someone faced similar issue or know of solution?

Thanks,

[WelterM]

Has there been a solution for this? I'm using version 2.51.4885.581, and I can't get the Word Wrap to work for column headers in a Table or a Matrix. The slider is on, but doesn't make any difference.

[RamySaroufim]

Hello @WelterM,

Can you please send a screenshot for your Table/Matrix and the property pane settings?

I'm assuming you are using the new Table/Matrix. Right?

If you are unsure, please create a new Table/Matrix visual, fill it with data, and try the word wrapping settings.

Also, note that when you toggle the option to "ON", it will not have effect until you reduce the column width.

[WelterM]

Hello, @RamySaroufim;

You hit the nail on the head there. I finally figured out that I had to reduce the header width. I tried to reduce the column width, in the body of the column, but that wasn't possible. I finally found how to reduce the header width. And that worked. I wish there was a way to center align the header.

[RamySaroufim]

@WelterM, Glad it worked!

More good news: Actually there is a way to center align the header!

You can either do it for all headers, under "Column headers"

Or you can do it for a specific column, under "Field formatting"

Ramy

[WelterM]

I don't see an alignment option.

[RamySaroufim]

Ah .. It seems you are using an old version of PowerBI Desktop. Latest (Feb 2018) is v2.55.x.x

You can download the latest version here:

https://www.microsoft.com/en-us/download/details.aspx?id=45331

Ramy

[WelterM]

Got it. Yes, I'm on 2.51.4885.581. I'll have to check with my company and see if there are plans to upgrade soon. Thank you so much.

[RamySaroufim]

Hello Cambell,

This is actually by design. Word wrapping for the regular Matrix Visual works only on Row Headers that span multiple rows (not on the last level).

Good news is, we have a new Matrix Visual that supports word-wrapping across the board for every cell. It is still in Preivew, it will be rolled out in a future release. You can enable it from the Desktop Options and Settings > Options > Preview features > New table and matrix visuals.

[v-yuezhe-msft]

Hi @cambell,

Do you use the latest version of Power BI Desktop(Version: 2.46.4732.461)? I turn on the word wrap slider option under the row header selector, everything works as expected.

Thanks,
Lydia Zhang

[cambell]

Hi,

It was the normal matrix that I wanted word wrap to work on (it has a slider for it that I can't get to work). I've updated my power BI and I've got it to work on the new matrix but it won't let me have two column headers like i do in the normal matrix (see picture I posted before). Any ideas?

Thanks,

Cambell 

[v-yuezhe-msft]

Hi @cambell,

I can reproduce the issue that word wrap doesn't work for row header in normal Matrix visual, I will report this issue internally and post back once I get updates.

Besides, yes, the new Matrix won't let you have two column headers like you do in the normal matrix. And the word wrap feature is not available for column header in normal Matrix visual, you can submit an idea in this forum:https://ideas.powerbi.com/forums/265200.

Thanks,
Lydia Zhang

[Greg_Deckler]

Yes, there is a slider for wrapping column headers. Remember, the new matrix visualization is still in Preview so not everything necessarily works 100%.