2024 Week 30 | Power BI: SVG Filters

Introduction

This week’s challenge was inspired by an XKCD comic and Kamala Harris’ love of Venn diagrams. 

Leveraging a prior challenge by Phil Seamark, this challenge we are going to apply SVG filters to make the shapes appear hand drawn XKCD style, and import XKCD font via the HTML content visual.

XKCD font can be embedded with base64 for use in core visuals — this is provided by Daniel Marsh-Patrick and can be found in the solution file.

A second, and optional challenge is to create a line chart, with the ability to hover over points and utilise aria labels as tooltips. 

Requirements

  1. Obtain the data from Google Trends or Github
  2. Import and model data
  3. Create your own or obtain a Venn diagram SVG measure from a previous challenge
  4. Within the measure:
    1. Create 3 intersecting circles
    2. Name each circle
    3. Place labels within the intersecting pieces
    4. Add a SVG filter that resembles the XKCD style
    5. TIP : SVG Pie Chart (with xkcd turbulence) x 2 • REPL • Svelte
    6. Change default font to XKCD font (url for HTML, base64 for native visual)
    7. TIP : xkcd font by aaizemberg (roadtolarissa.com)
  5. EXTRA CREDIT – Line Chart
    1. With the HTML content visual (full, not HTML Lite)
    2. Create an SVG line chart of Venn diagram searches over time
    3. TIP : https://kerrykolosko.com/portfolio-category/svg-templates/
    4. Add axes and axes labels and chart title
    5. Change default font to XKCD font
    6. Add a SVG filter that resembles the XKCD style
    7. Add animations that change line points from transparent to opaque upon mouseover
    8. Create a tooltip upon mouseover
    9. TIP : aria labels are an option

Dataset

This week’s dataset is downloadable from Google Trends or via https://github.com/kolky001/Workout-Wednesday-2023/blob/main/VennDiagram-multiTimeline.csv 

Share

After you finish your workout, share on Twitter using the hashtags #WOW2024 and #PowerBI, and tag @MMarie, @shan_gsd, @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

Coming soon.

Scroll to Top