Skip to main content

Power BI

Needs Votes

Better data label customization

Vote (544) Share
Daniel's profile image

Daniel on 25 May 2016 04:06:06

When data labels are enabled on visualization types where data overlaps (such as clustered bar charts and line charts), there are occasions where data labels do not display, or it is difficult to tell which label corresponds to which bar/line. There should be better customization options for Data Labels, which would ease comprehension of various visualizations. In particular, for the varied types of bar charts:

- Label location: start of bar, middle of bar, end of bar, end of chart
- Label/Background colour matching: change the label's text or background to match the bar to which it corresponds
- Label Stacking? If a label would overlap with another, display both of them slightly offset, instead of only displaying one label.

Comments (59)
Daniel's profile image Profile Picture

Carlos on 05 Jul 2020 23:21:05

RE: Better data label customization

This is a great ideia, we need more freedon to change label.

Daniel's profile image Profile Picture

Monika on 05 Jul 2020 23:19:28

RE: Better data label customization

It would be great if we could edit labels on all charts, not limited to only bar charts. Many times I would like to show one label for a pie chart, but have to show all or create a work around. The ability to move and format labels similar to how we can in Excel.

Daniel's profile image Profile Picture

Power BI User on 05 Jul 2020 23:18:21

RE: Better data label customization

They have done this on line chart before. I just can't understand why its not available on column, bar and other charts as well.

https://powerbi.microsoft.com/en-us/blog/more-power-bi-feature-updates-power-bi-desktop-december-update-and-new-power-bi-service-features/#formatlabels

Daniel's profile image Profile Picture

Adam Harper on 05 Jul 2020 23:10:59

RE: Better data label customization

This has been an absolute headache for me. The lack of control of displaying how and when a data label is shown seems like basic functionality. The algorithm is not smart enough. It's constantly overlapping or you can't tell which value belongs with a line or bar. It would be great to specify intervals (i.e., every other point). Let's make this one happen.

Daniel's profile image Profile Picture

Caroline on 05 Jul 2020 23:10:41

RE: Better data label customization

Good idea. And it would be also good to be able to chose on which data we want data labels. Today if you select Data Label it is displayed on all measures (bar, lines, etc.)

Daniel's profile image Profile Picture

Corey Jones on 05 Jul 2020 23:05:51

RE: Better data label customization

This is a great idea. It would be great to be able to turn off labels on line part of bar+line chart.

Daniel's profile image Profile Picture

ManNVSM on 05 Jul 2020 23:05:46

RE: Better data label customization

This would make it easier for user to know what data labels apply to Legend or Line.

Daniel's profile image Profile Picture

Briton Wells on 05 Jul 2020 23:03:44

RE: Better data label customization

A few things I have run into:

When mixing bar+line chart, I would like to be able to configure data labels for the column/line seperately

Able to turn off background and/or change the colour of the data label background when it is inside the bar

Daniel's profile image Profile Picture

Doug on 05 Jul 2020 23:02:46

RE: Better data label customization

Just allow us to turn off the lines or the column labels.

Daniel's profile image Profile Picture

Astrid on 05 Jul 2020 23:00:15

RE: Better data label customization

It would be great for the data labeling to be consistent. I've got stacked bar charts with random allocation of the labels.

Also with respect to stacked bar charts it would be great to be able to have a "total" label appear at the end of each bar.