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 (231)
- Merged Idea (29)
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.
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.
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.
RE: Add word wrap to bar chart Y-Axis Labels
There is no option to format the text in the category label. I would like some basic abilities for text manipulation on display like:
Word Wrap
Size of Text
Color of Text
Position (both vertical and horizontal)
If possible I would also love an option to have the text auto format based on the size of the box
RE: Add word wrap to bar chart Y-Axis Labels
Currently I work on a project to create Financial Statement Report or Dashboard using Power BI Desktop.
I create a measure to calculate Current Ratio. Since financial ratios (including Current Ratio) need explanation, i wrote a DAX expression with If statement to create measure that return dynamic long text (string). The the problem now is, i didn't found any appropriate visual for my dynamic long text. Card works, but it doesn't support wrap text properties for the values (the wrap property only works for category name).
RE: Add word wrap to bar chart Y-Axis Labels
Please add this formatting option. Space on the canvas is limited. Often there is no room to expand the chart to display all the legends fully. Yet there is so much white space in the chart object itself to fully show the legend - if the legend items could only be displayed over two lines.
RE: Add word wrap to bar chart Y-Axis Labels
Please add this. Currently find these bar charts unusable if even a single value is too long to fit the space.
RE: Add word wrap to bar chart Y-Axis Labels
Why on earth can't you implement this ?!?!?!!!