2023 Week 42 | Power BI: Add value to tables with SVGs

Power BI, Workout Wednesday / By

Introduction

Welcome back to Workout Wednesday! This week we’re adding value to tables using SVG images! I was inspired by Sean Miller’s Week 16 Tableau challenge, and thought we could re-create this in Power BI.

In this challenge, you’ll use various techniques to enhance the presentation of data within your Power BI table visual. These techniques include utilizing built-in conditional formatting, creating custom measures for conditional formatting, and incorporating SVG images.

Fun fact – I used ChatGPT while I was generating my SVG images! I didn’t expect it to work but I had a good experience! You can find all of the measures I used in the report in the solution file.

Requirements

Get and transform data

  1. Get data from Sean’s Data.World dataset
    • If you do not have a Data.World account, you can use this Excel file.

Create measures

  1. Create measures for:
    • Total Sales
    • Sales Rank
    • Profit Rank
    • 2021 Sales
    • 2021 Profit
    • YoY % Change in Sales (2020 – 2021)
    • Change in Profit (2020 – 2021)
  2. Create your SVG measures for:
    • Sales rank (square with a number in it)
    • Profit rank (circle with a number in it)
    • Change in profit (triangle)

Create your table

  1. Add a table to the canvas
  2. Add the following measures to your table:
    • Item (column)
    • Sales rank SVG
    • 2021 Sales
    • YoY Sales %
    • Profit rank SVG
    • 2021 Profit
    • Change in profit
  3. Use the inbuilt conditional formatting where you can!
    • 2021 Sales uses data bars conditional formatting
    • YoY Sales % uses icons conditional formatting
    • 2021 Profit uses both background and text color conditional formatting
    • Change in Profit uses the SVG measure as the icon conditional formatting
  4. Ensure that all visuals meet the minimum standards of having alt text, that the tab order in your report makes sense, and that your color choices meet the minimum standards. 
 

Dataset

This week’s challenge uses the SuperStore dataset. You can find it on Data.World or download the Excel file.

Share

After you finish your workout, share on Twitter using the hashtags #WOW2023 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

Solution File available for download via Data Stories Gallery.

Scroll to Top