Highlight Key Values in Power BI Line/Area Charts (Highest, Lowest, First, Last)

Iwa Sanjaya

·

Follow

Published in

Learning Data

·

4 min read

·

Apr 8, 2024

43

Listen

Share

While line charts are great for showing trends over time, the default way of displaying data points with markers can clutter the chart, especially when you also want to include data labels. This is because Power BI displays markers for all data points by default. To prioritize clarity and highlight key trends, we can leverage DAX formulas. This allows us to focus on specific values like the highest, lowest, first, and last data points.

Part 1: Identifying Maximum and Minimum Values

Step 1: Constructing a Line Chart

Since markers alone only indicate single data points (highest and lowest values), the line is essential for visualizing the trend over time. To demonstrate this step-by-step, I’ll use a dataset from Maven Analytics, specifically the World Economic Indicators.

Let’s create a line chart with the date table (year) on the x-axis and the ‘death rate’ table on the y-axis. For now, we’ll focus on just the line without the markers.