In this blog, you will learn how to highlight maximum and minimum values in a Power BI Line chart.
Let’s get started-
Download the sample Dataset from below link-
Follow these steps-
Step-1: Add a Line chart visualization to the Report canvas and drag some columns.

Line chart example
Step-2: Now create two measures for minimum and maximum sales, and write the following DAX code below.
MAX Sales = VAR GetAllMarket = ALLSELECTED(Orders[Market]) VAR GetMaxValue= MAXX(GetAllMarket, CALCULATE(SUM(Orders[Sales]))) RETURN IF(SUM(Orders[Sales]) = GetMaxValue, GetMaxValue, Blank())
MIN Sales = VAR GetAllMarket = ALLSELECTED(Orders[Market]) VAR GetMinValue= MINX(GetAllMarket, CALCULATE(SUM(Orders[Sales]))) RETURN IF(SUM(Orders[Sales]) = GetMinValue, GetMinValue, Blank())
Step-3: Now add both measures into visual.

Display min & max values on visual
Enable Data labels only for MIN & MAX values-
Follow these steps-
Step-1: Go to Format section > Enable Data labels.
Step-2: It will enables data labels for all, but we want see data labels only for max & min. so follow below steps-
Under Data labels > Enable customize series > and for Sales turned off Show.

Turned off Data labels for sales
Change Data color for MIN & MAX values-
Go to Format section > Data color > Change color individually.

Change Data colors for line chart
Add Max & Min line into Line chart visual-
Refer for more details: Add max & min lines into line chart visuals
Select Line chart > Go to Analytics Pane > Add Min & MAX line for Sales.

Add max & min line into line visuals
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.