Convert to Trendline

Back

Convert to Trendline

Max, Min & Last Labels for Line Charts

Build

Overview

Features

Prompts

Help

Key Features

A line chart is far more useful when it names its own peaks and troughs — the highest point in green above the line, the lowest in red below, and the latest value called out at the end. Power BI's built-in data labels can't do that; they style every point the same. The real version needs visual-level calculations for each callout, per-series formatting and positioning, a bit of invisible padding so the labels don't clip, and a canvas tooltip — all set through visual properties the UI doesn't expose. This skill adds the lot in one command, and it reads your existing line colour so the smooth line and area fill keep the look you already have — run it with /trendline-callouts.

How it works

Type /trendline-callouts, point it at your line chart(s), and the skill applies everything:

Reads your chart — pulls the main measure and date field from the visual, and reads its current line colour
Adds the callouts — visual-level calculations for the max, min, and last value, plus two invisible ones that pad the axis so labels don't clip
Styles each one — max in green above the line, min in red below, last in grey at the end, with the label numbers formatted to match the measure (%, currency, and so on)
Polishes the line — turns on a smooth line with an area fill in your existing line colour, and hides the axes and chrome for a clean look
Adds a hover tooltip — a small canvas tooltip page showing just the main measure, linked to the chart
Creates the colour measures — _Color Green, _Color Red, and _Color Last are added to your model if they're missing, so you can restyle every callout from one place

What you get

A max label — green background, above the highest point
A min label — red background, below the lowest point
A last label — grey background, on the most recent value
Correctly formatted numbers — the labels follow the measure's format (percentage, currency, units)
A smooth line with area fill — in your existing line colour, axes and chrome hidden for a clean look
A hover tooltip — a linked canvas tooltip page showing the main measure
Colour measures — _Color Green / _Color Red / _Color Last, created in the model if missing, so you can recolour every callout from one spot