2025 Week 10 | Power BI: Line Chart with dynamic formatting

Power BI, Workout Wednesday / By

Introduction

Hi to everybody! I am so happy to be among the new contributors for Workout Wednesday. I believe these kinds of challenges bring tremendous value to everyone who tries something new on a regular basis—you’ll learn so much!

We will look at the consumer price index for chocolate in the Euro region. As you might have all noticed, the prices have gone up significantly. But every month? This is what we are going to find out.

This, this week’s challenge focuses on customizing the look and feel of a line chart. We’ll explore using visual calculations for line charts to implement dynamic colors based on the previous value of a time series, experiment with dynamic marker styles, and let users decide how many details they want to see. 

And this is how it should look like: Please note, that the visual calculations cannot be published to the web as of today.

 

Requirements

  1. Download the sample data from the Data World Website. 
  2. Make sure that the visual calculations preview feature is turned on. 
  3. Create a line chart that shows the development of the price index of chocolate over time.
  4. Add visual calculations to include the previous value, the change to the previous value and columns for only declined (vs previous month) and increased values (vs previous month), respectively.
  5. Format the lines and markers of the increased and declined values accordingly:
    • Use different colors for increased vs. decreased values compared to previous month. 
    • Customize marker styles.
  6. Optional: Create bookmarks and include a bookmark slicer to let the user decide the information they want to see.

Dataset

This week’s data is about the consumer price index for chocolate in the Euro area (Source: ECB Data Portal). The sample data can be found on the data.world website here. Note: Data.World requires you to create a free account to access the data.

Share

After you finish your workout, share on social media using the hashtags #WOW2025 and #PowerBI. 
On Linkedin, tag Meagan Longoria, Shannon Lindsay, and Kerry Kolosko and Diana Ackermann.
On Bluesky, tag @mmarie.bsky.social, @shan-gsd.bsky.social, and @merrykerry.bsky.social.

Solution

Solution File

You can download the solution file here.

Watch

Here you’ll find a walkthrough video.

Scroll to Top