Skip to main content

Power BI

New

Multi-line column headers for tables with word wrap

Vote (56) Share
Jamie Llewellyn's profile image

Jamie Llewellyn on 07 Apr 2016 02:19:42

There are a lot of excel formatting features that would be nice in Power BI but at the top of my list is word wrapping for long column heading names. For example, Proposed Fund Purchase Price would wrap to
|Proposed Fund |
|Purchase Price |
| $120,000|
because the data in that column would fit nicely under that text and I could fit more columns on my table.

Comments (6)
Jamie Llewellyn's profile image Profile Picture

630ffbaf 9d7d-4bda-bafb-2512624d0123 on 05 Jul 2020 23:39:41

RE: Multi-line column headers for tables with word wrap

Just checked - there is a word-wrap feature for column headings (Nov 2018 PBI Desktop).

Jamie Llewellyn's profile image Profile Picture

ffbe43f0 9082-4d4e-a4c0-5803e7f90581 on 05 Jul 2020 23:13:35

RE: Multi-line column headers for tables with word wrap

This is a critical and simple feature to allow the headers to be wrapped based on the table width defined by the user.

Jamie Llewellyn's profile image Profile Picture

c46fd02f 1a81-4c5f-a32e-d8515cb039b8 on 05 Jul 2020 22:37:10

RE: Multi-line column headers for tables with word wrap

It is not always necessary to use abbreviations in the column. Therefore we need an analogue "wrap text" in Excel (and change row height)

Jamie Llewellyn's profile image Profile Picture

4fb0c719 510c-41f4-83fc-4b57fac7d150 on 05 Jul 2020 22:26:10

RE: Multi-line column headers for tables with word wrap

I think that this is a duplicate request. - See https://ideas.powerbi.com/forums/265200-power-bi/suggestions/6700612-text-wrap-in-tables-cards-etc-in-dashboards

Jamie Llewellyn's profile image Profile Picture

af0019aa 9a7e-4776-9021-7b1171cd13bc on 05 Jul 2020 22:21:20

RE: Multi-line column headers for tables with word wrap

Actually AFAIK Excel doesn't do this - it would automatically widen such a table column to the full width of the column heading. In Excel you can manually set the width and manually set the column headings to wrap. This may be "too hard" and not worth working on - I imagine it would take a lot of coding to judge when to wrap and how wide to make the column. Perhaps manual column width and wrapping controls are a more realistic ask?

Jamie Llewellyn's profile image Profile Picture

af0019aa 9a7e-4776-9021-7b1171cd13bc on 05 Jul 2020 22:21:20

RE: Multi-line column headers for tables with word wrap

I'm not sure why this has been categorized under Custom Visuals - I think it refers to the built-in table object?