2023 Week 13 | Power BI: Create a connected scatterplot with image markers

Introduction

This week we are getting a bit artistic and taking inspiration from a visual that was recently published by Robin Rohwer on Twitter. She created a connected scatterplot that uses a flower emoji to represent each point. I thought her visual was wonderful, so I set out to create something like it in Power BI. That is now your challenge for the week. The flexibility of the Deneb custom visual allows us not only to create more advanced visuals such as connected scatterplots but also to customize the marks we use in the plot. Your challenge is to create a connected scatterplot and customize it to use an image for each point. 

If you like connected Scatterplots, check out Kerry’s exercise using the PlotlyJS custom visual. 

Requirements

  • Create a connected scatterplot with year on the x-axis and date (e.g., April 15) on the y-axis. 
  • Use an image of your choice to mark each year in the plot. (In the example, we use an SVG path to define the image. You can find the path used for the image here.)
  • Use a background image on the page. The image should be related to the data or theme of the report.  (The image in the example report comes from Wikipedia. It is cropped and flipped.)

Dataset

Share

After you finish your workout, share on Twitter using the hashtags #WOW2023 and #PowerBI, and tag @MMarie, @shan_gsd, and @KerryKolosko. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year.

Solution

Scroll to Top