Convert to Trendline
Max, Min & Last Labels for Line Charts
Build
Overview
Features
Prompts
Troubleshooting
Key Features
You want max in red above the line, min in green below, and the last value labeled — but Power BI's built-in data labels apply the same style to every point. Getting this right requires visual-level calculations, custom formatting per series, and a canvas tooltip, all through visual.json properties that aren't exposed in the UI. This skill adds all five visual calculations with full formatting and a linked tooltip in one command.
How it works
Type /trendline-callouts, point it to your line chart, and the skill applies everything:
Extracts the main measure and date field from your visual
Adds 5 visual-level calculations: Max, Min, Last, YAxis Max, YAxis Min
Formats each with distinct colors, label positions, markers, and area fill
Creates a canvas tooltip page with a simple card showing the main measure
Links the tooltip to the visual
What you get
Max label — red background, positioned above the data point
Min label — green background, positioned below the data point
Last label — gray background, showing the most recent value
YAxis padding — invisible max/min series that create space for labels
Canvas tooltip — separate page with a card visual for clean hover detail
Smooth line with area fill — applied to the main measure series
Explore more in this category
Absolute / Percentage Toggle
Build
Add a two-button tile slicer to any chart that switches between absolute values and a percentage variant, with a dynamic format string and auto-derived chart title.
Active Filters Card Visual
Build
Generate a card visual that dynamically displays all currently active slicer and filter selections.
Clone Page
Build
Clone any report page with all visuals, bookmark navigators, interactions, and drillthrough bindings as a fully independent copy.
Create Tooltip
Build