Region
New Zealand Flag
NZ
UK Flag
UK

How to emphasise a data point in Power BI

This blog post draws inspiration from Storytellingwithdata.com, where Cole Nussbaumer Knaflic emphasizes the importance of highlighting and labelling critical data points to create compelling data narratives. While the original example focuses on achieving this in Excel, we’ll explore how to achieve similar results using Power BI, a popular data visualization tool.

In my Data Visualisation courses, I focus on essential principles for effective communication with data. In this post, I show how to implement best practices in Data Visualisation using Power BI.

This is my starting point as created by Power BI by default.

Clean up the Default

First, let’s tidy up this visual by removing distracting elements and ensuring clear labelling.

To achieve this in Power BI, follow these steps:

  1. Remove Line Color:
    • Go to Format Visual.
    • Under Lines, set the color for all lines to a consistent shade of grey.
  2. Directly Label Series:
    • While still in Format Visual, enable Series Labels.
    • Choose the Right position for the series labels.
  3. Eliminate Gridlines:
    • In Format Visual, disable Horizontal Gridlines.
  4. Adjust Chart Titles and Axis Labels:
    • Customize the following:
      • Title: Set an informative title for your chart.
      • X-axis Label: Modify the label for the X-axis.
      • Y-axis Label: Customize the Y-axis label.

Refer to the screenshots below.

Now that we have a clean visual, let’s move on to the next step and add some focus.

Highlight Important Values

Next, we can focus on emphasizing specific data points within this line chart. You can use this approach to highlight any data point. My example below will focus on making the latest and the highest number stand out.

This can be done in three steps:

  1. Making sure we have a separate date table.
  2. Creating new measures for the values we want to highlight.
  3. Adding the new measures to the line graph and adjusting the formatting.
Step 1: Ensure a Separate Calendar Table

To enable the following DAX calculations, you’ll need a separate calendar table (‘Dates’ in this example) linked to the fact table.

Note: If you are not familiar the use of fact and dimension tables in Power BI, here is a good reference by Microsoft: Understand star schema and the importance for Power BI – Power BI | Microsoft Learn

If you want to dive deeper into the Dimensional Modelling, consider our public or private training courses.  

Step 2: Create Measures for Highlighting Values

If you want to make sure that you always highlight the latest value, the first step is to determine the latest period. In my case this is the latest year from the fact table containing the data. 

  • To identify the latest period, I have created a new measure using DAX:
    Latest Year = YEAR((LASTDATE(ALL('DATA TO GRAPH (DATA)'[Original Date].[Date]))))
  • Then I have created another measure for the latest value. This is the field I have added to the line chart.
    Latest Fundraiser = CALCULATE(SUM('DATA TO GRAPH (DATA)'[Fundraiser]), FILTER(Dates, Dates[Year]=[Latest Year] ))
  • We can use a table visual to double-check that the latest measure contains only one value corresponding to the latest period.

Once I have added the ‘Latest Fundraiser’ measure to my line chart, all I had to do, was to format it.

Step 3: Format Visual
  • Adjust Line Color: Go to Format Visual. Under Lines, set the color for the ‘Latest Fundraiser’ measure to blue.
  • Label Data Points: Go to Format Visual > Data Labels. Select the new measure ‘Latest Fundraiser’, set Show to “On,” and customize the label color.
  • Add a Marker: Go to Format Visual > Marker. Choose the new measure ‘Latest Fundraiser’, set Show marker to “On,” and customize the marker shape, size, and color.

Below are the screenshots of my format settings.

Indicate Forecast with dashed lines

In this final step, I have added the dashed lines for the forecast figures and displayed all latest values.

Here is how:

Create Dashed Forecast Lines:

  • Apply the same approach as before.
  • Create new measures to calculate actual and forecast values separately.
  • Add these measures to your visual.
  • Format each line individually.

Example Illustration:

  • In our line chart with a “Weddings” series, we set the line for “Weddings” to dashed.
  • We calculated the “Wedding Actual” measure, excluding data from 2020 (assuming that’s the forecast period).
  • We have added measures to the line chart and formatted “Weddings” with a dashed line and “Wedding Actual” as a solid line.

DAX Expressions:

  • “Wedding Actual” represented with solid grey line:
    Wedding Actual = CALCULATE(SUM('DATA TO GRAPH (DATA)'[Wedding]), FILTER('DATA TO GRAPH (DATA)', 'DATA TO GRAPH (DATA)'[TYPE]="ACTUAL"))
  • “Fundraisers” forecast represented by the dashed blue line:
    Fundraiser Forecast = CALCULATE(SUM('DATA TO GRAPH (DATA)'[Fundraiser]), FILTER('DATA TO GRAPH (DATA)', 'DATA TO GRAPH (DATA)'[Year]=[Latest Year]-1||'DATA TO GRAPH (DATA)'[Year]=[Latest Year]))

Other considerations: To align the numbers next to the series labels I have used a separate table visual. This, of course, only works while the data is static.

You can view the live workbook below:

Or download from Git repository: https://github.com/juliagusman123/storytelling-with-data-power-bi

In summary, when presenting data, it’s crucial to focus on the message you want to convey. Highlighting the latest, highest, or lowest numbers can effectively emphasize key points. This post has demonstrated quick techniques to achieve this using DAX to create highlight measures and formatting options to customize colors, styles, and labels in your visualizations.

If you enjoy learning with us, consider our public and private training courses.

If you have any comments or questions, please feel free to get in touch with me via my email juliag@altis.com.au

Share

Facebook
Twitter
LinkedIn
WhatsApp

Leave a Reply

Your email address will not be published. Required fields are marked *

Recent

Connect with us

If you’d like to be kept in the loop on courses, events and other related topics, simply complete your details and we’ll add you to our list.

We use cookies to improve your experience and support our mission.
Read more about it here. By using our sites, you agree to our use of cookies.