Skip to main content
Microsoft Idea

Power BI

Planned

Add word wrap to bar chart Y-Axis Labels

Vote (2021) Share
David Vella's profile image

David Vella on 03 Mar 2017 15:47:34

If you have long names on a bar chart Y-Axis they get truncated. This is a problem if you have ones that start with something similar. Could we have a word wrap option on the format menu that takes advantage of the vertical space so the whole label can be shown.

Administrator on 01 Apr 2024 05:43:28

We are working on this

Comments (228)
David Vella's profile image Profile Picture

on 18 Apr 2022 20:56:03

RE: Add word wrap to bar chart Y-Axis Labels

allow text wrapping in visuals such as treemaps and bar charts

David Vella's profile image Profile Picture

on 18 Apr 2022 20:56:03

RE: Add word wrap to bar chart Y-Axis Labels

It seems you've added the title functionality to some visuals, but why not go crazy and enable text wrapping in ALL data label fields for report visuals?!

At this point I could build a better data visual in PPT/Excel and that's based purely on my frustration with every "Category label" ending in "..."

David Vella's profile image Profile Picture

on 18 Apr 2022 20:55:52

RE: Add word wrap to bar chart Y-Axis Labels

Have the ability to wrap the legend text so you don't have to scroll to see what you are looking at. 

David Vella's profile image Profile Picture

on 18 Apr 2022 20:55:52

RE: Add word wrap to bar chart Y-Axis Labels

I suggest to add wrap text on Treemap

David Vella's profile image Profile Picture

on 18 Apr 2022 20:55:52

RE: Add word wrap to bar chart Y-Axis Labels

Please could you implement "Category" word wrapping for Pie and Doughnut visuals.

Currently the only way to include as much text as possible is to make it so small it practically becomes illegible, and even then depending the size and placement of the visual and the content of the category you still end up with "..." and loss of useful context.

It would actually make sense to roll out word wrap across the board for all visuals.

David Vella's profile image Profile Picture

on 18 Apr 2022 20:55:52

RE: Add word wrap to bar chart Y-Axis Labels

Quite often the labels in legend fields stretch wider than the column chart can reasonably be. It would be helpful to be able to set the legend to word wrap so it goes to 2 or three shorter lines rather than truncating and hiding some classes off the right hand side of the bar or column chart

David Vella's profile image Profile Picture

on 18 Apr 2022 20:53:27

RE: Add word wrap to bar chart Y-Axis Labels

When displaying map data at a zoomed out level. Map visualisations only display once no matter how many times that geographic location is visually present. For example: the if the USA is on the left had side of the map with visualisations present then if the USA is also appearing on the right hand side of the same map, no visualisation data will appear on the right most version.

For someone inspecting the map data, it might be important for all Geographic visualisations to appear and wrap in the same way the underlying map does.

David Vella's profile image Profile Picture

on 18 Apr 2022 20:53:27

RE: Add word wrap to bar chart Y-Axis Labels

There is no provision in Power BI to wrap the categories of legend according to length or by one of these special characters (, / * ; - ). For example, I am creating a filled map where the length of the label is more than 50 in some cases - e.g. Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sputnik V. This is a problem in bar plots as well as in the case of filled map.

If there are more number of categories in legend and if the legend is positioned in top or bottom, not all the legends are visible. Therefore, there should be option to show legend in more than one row.

David Vella's profile image Profile Picture

on 18 Apr 2022 20:53:27

RE: Add word wrap to bar chart Y-Axis Labels

On charts it would be helpful to have much more functionality over the legend format e.g.

- ability to drag and move it around to where you want it
- resize the legend box and ability to word wrap the legend titles (as can be done in excel)
- format background colors of a legend box

Interestingly SAP Cloud Analytics (which I view as generally inferior to Power BI, but that is just my perspective) has a lot of this functionality.

David Vella's profile image Profile Picture

on 18 Apr 2022 20:53:27

RE: Add word wrap to bar chart Y-Axis Labels

I would like Power BI charts & table to have the same functionality as excel charts & tables, eg line markers in line and combo charts; data label for select data series (as oppose to all data series); customizing the order in legends (can't do this at present); wrapping text in table (can't do this eith at preset) etc.

Merged Idea (29)