2022 Week 48 | Power BI: Conditional SVG Measures

Introduction

While we looked at SVG measures in a matrix in week 20, we are taking a different approach this week. SVG measures can be used in other visuals, and they can be designed to include links.  

In the below Power BI report, I’ve got 4 visuals populated by SVG measures. Initially, all 4 visuals show an envelope with a bow. The visual shown will change based upon the date. On the date shown in the title of each visual, the visual will render an open Christmas card that is clickable to navigate to a new WoW exercise. 

Requirements

  • Create a report that contains 4 visuals that are populated by SVG measures. The report can be holiday themed, or you can pick another theme. If you’d like to use the SVGs in the report shown, you can get the URLs from the Image Credits page.  
  • Use a visual other than a matrix to show your SVGs (hint: I used a custom visual called HTML Content.)
  • Make the SVG shown change based upon some condition. I used the date being less than current date as my condition, but you can use a selection in a slicer or anything you want.
  • Make at least one of the SVGs clickable so that it navigates to a URL. The URL should have something to do with data visualization (your favorite WoW exercises, your favorite visualizations, helpful data viz tools)

Dataset

There is no dataset for this week! I populated the report entirely from measures, so I started with a simple blank table ( “_Measures = {BLANK()}” in DAX)

Share

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

Download the pbix file here.

Scroll to Top