Jeffrey Weir on 27 Nov 2019 09:55:44
We need to be able to label specific data points with dynamically generated values (including text). Use cases include:
* Labeling the first or last point of line charts with values
* Labeling the last point of series in a line chart with the series name, to directly inform the user which series is which, rather than have them constantly move their eyes between a legend and the many series on a graph.
* Labeling particular values of interest, to aid storytelling.
These things are bulk-standard features of good dashboard design, and are essential in order to design optimal user-friendly dashboards with low cognitive burden.
Gotta say that humble ol' Excel is streets ahead of Power BI in regards to data labeling.
Note that measure-driven tooltips are NOT a substitute for this feature. We need ways to draw the users' attention to particular points or features without relying on mouse-over.
- Comments (22)
- Merged Idea (6)
RE: Measure-driven DataLabels
There is a workaround via Calculation Groups. It is not as nice as what we would want (e.g. a simple Measure to select as datalabels) but it does work. Only downside is, you cannot do any line breaksHere is a great video explaining how it works ... https://www.youtube.com/watch?v=1Yi1xn4RPMc
RE: Measure-driven DataLabels
Yes, this is desperately needed. The same concept that you did with "Dynamic titles". Please make this possible for "Dynamic Data Labels" using a measure. For example. I have bar chart with 2 bars and one of the bar values is 10% and the other is 60%. But I want the label showing to be 10/100 and 60/1000. So I would use a measure to show this labels.
RE: Measure-driven DataLabels
As it stand now, it's quite tedious to set up a linegraph to only show the data label for the latest datapoint.
I thought It could a nice idea to have this included with the "Label density" option provided, where setting its value to 1% will achieve this.
RE: Measure-driven DataLabels
I have a scatter plot with many nodes grouped in an area that I want to ignore, for the remaining nodes that are spread about I want to see their labels. It would be great to have some conditional formatting that could use a field in the data to control the visibility of the label.
For line graphs it would be good to use the same approach to only show the labels on the first and last points of a line.
RE: Measure-driven DataLabels
Ribbon charts with many series would be easier to interpret if the name of each series was displayed on either end of the ribbon. It would be nice to have the option of displaying the start and finish rank as well in this label e.g. if the "rabbit" series changed in rank from 5 to 4 I would like to show Rabbit (5) label on the left of the ribbon and Rabbit (4) on the right of the ribbon.
RE: Measure-driven DataLabels
Easier option to add the last data label and/or the first data label from a graph. At this moment there is no easy option available instead I need to use space to have the visualization card boxes for each of the 4 lines in the graph. I would like that Power Bi would have easier options to only show either or both of the first and the last data option.
RE: Measure-driven DataLabels
currently, when selecting data labels in line chart, there is no option to show the latest value only. we need this. tableau does exactly this (https://onlinehelp.tableau.com/current/pro/desktop/en-us/annotations_marklabels_showhideworksheet.html)
RE: Measure-driven DataLabels
Would be very cool to have measure driven data label. A simple scenario is with Total Labels for example, doesn't support non-additive measures - it simply sums up the values. It would be very nice if we can customize what is shown in data labels using measures.
RE: Measure-driven DataLabels
Yes!!! We have needed this for a long time!