Skip to main content

Power BI

Needs Votes

Measure-driven DataLabels

Vote (295) Share
Jeffrey Weir's profile image

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 (6)
Jeffrey Weir's profile image Profile Picture

49caf22f 2327-470c-b1e6-53b6b487fffa on 06 Jul 2020 00:13:06

RE: Measure-driven DataLabels

This is a common request from Tableau users. Please include it.

Jeffrey Weir's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:11:26

RE: Measure-driven DataLabels

This would be a very welcome addition. Agree 100% with the ‘story telling’ aspect. Not all data points are equal, so the ability to dynamically label items of interest is a game changer.

Jeffrey Weir's profile image Profile Picture

956565aa 7e9c-4ca8-8b6f-9f03b903d88f on 06 Jul 2020 00:11:01

RE: Measure-driven DataLabels

Yes! We need more control over adding labels to specific data points rather than global. I would love to see the capabilities as described in "Storytelling with Data" by Cole Knaflic.

Jeffrey Weir's profile image Profile Picture

65c88a40 2a5b-4b65-9906-a3d11145690d on 06 Jul 2020 00:09:46

RE: Measure-driven DataLabels

Want to know what this idea will buy you? https://twitter.com/InsightsMachine/status/1237501238817640448

Jeffrey Weir's profile image Profile Picture

bd782228 0267-4a31-9217-4d1c7dce8792 on 06 Jul 2020 00:08:49

RE: Measure-driven DataLabels

I'm currently using Cards and Advance Cards (to get conditional formatting, EG. a Branch name goes Red if [condition]) to do this.

This is fairly basic, but so important for making dynamic reports.

Jeffrey Weir's profile image Profile Picture

5b9fcad7 8db8-4cfe-a5a8-356b485df118 on 06 Jul 2020 00:03:52

RE: Measure-driven DataLabels

Good idea. I‘d like to add Maximum and Minimum to the list of line chart data points that need to be labeled by measure driven labels