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 (53)
RE: Better data label customization
Also the ability to display 'total' values instead of the legend detail. We can change to a bar/line chart and display both as a workaround but even with this you are unable to only show line data labels!
RE: Better data label customization
I would like to set the min/max on Display unit. For example: I have a report where I have no interest to see the numbers in Billions (bn.) but I would like to see them in Millions and lower.
I would also like to see an option like SQLBI (OkViz) have in their card visual called Culture Code. There I can choose my locale for the visual and it will display correctly in a browser regardless of the browsers locale settings. This way we force the correct culture code to the end user.
RE: Better data label customization
I would like to have custom format option for the shown value. Especially add ' h' suffix for time values. And conditional formatting would be also nice, to show over the limit values with red background (warning color). These are a real world need that can be achieved with other BI tools.
RE: Better data label customization
Can not believe that two years later this is still an open issue. Chart readability is a main concern for the users!
RE: Better data label customization
I agree with all these comments. I need to be able to label must smaller slices than PBI currently allows. I also find myself taking a screenshot and labeling manually with an image editor. Bah!
RE: Better data label customization
I have the same issue as Tian.
With chart type of "Line and Stacked Chart" the data labels often collide. I want to see data labels for only the bar and remove the label for the line, but there's no way to turn the display of a single data label.
RE: Better data label customization
Same issue: Choose the data label position in line visual, with two or more lines. thanks
RE: Better data label customization
Same issue. With 2 line graphs in one visual, where data points are close to each other, some data points with lower value show up above the other category with higher value! very annoying feature that I could not get over with different axis spacing and background labels etc. Should be able to move labels like in excel (this should have minimum excel level ability)
RE: Better data label customization
With chart type of "Line and Stacked Chart" the data labels often collide. I want to see data labels for only the bar and remove the label for the line, but there's no way to turn the display of a single data label.
RE: Better data label customization
Would like to be able to turn off data labels for the line in a line, column combo chart as it is hard to tell which label goes to which part of the chart.