Power BI

2023 Week 04 | Power BI: Mortgage Rates Area Chart

Introduction Hello everyone! I’m excited to have my first challenge of 2023 up and ready for your enjoyment. Last year I got a reputation as providing challenges that were, let’s say….a little on the easier side, so this year I’m just going to own it!  I was scrolling Twitter in hopes of finding some inspiration …

2023 Week 04 | Power BI: Mortgage Rates Area Chart Read More

Vertical Area Chart describing Republican and Democrat shifts in ideology

2023 Week 03 | Power BI: Vertical Area Chart

Introduction Howdy All! We’re all topsy-turvey this week turning line charts on their side! ⇩ This weeks challenge was inspired by Nick Desbarats article Are Vertical Line Charts Ever a Good Idea? Can you find some other examples where vertical line charts may be a good idea? ⋟^◕ܫ◕^⋞ Happy Vizzing Requirements Power Query Obtain the voteview_polarization_data.csv …

2023 Week 03 | Power BI: Vertical Area Chart Read More

Area charts with layered series

2023 Week 02 | Power BI: Create layered line/area charts with labels and annotations

Introduction For our second week of Workout Wednesday 2023 Power BI Edition, we are taking inspiration from a recent Washington Post interactive story titled “See just how bad a year it was for your retirement account — and why”. The article looks at the closing price of the S&P 500, comparing the value at the …

2023 Week 02 | Power BI: Create layered line/area charts with labels and annotations Read More

2023 Week 01 | Power BI: Use DAX to control visual display

Introduction Welcome to Workout Wednesday 2023, Power BI edition! If this is your first time joining us, we’re happy you’re here. The goal of this initiative is to help you build your Power BI skills. We provide the data and the instructions, and you build the visuals! We hope you have fun and learn a new …

2023 Week 01 | Power BI: Use DAX to control visual display Read More

Power BI page featuring an image carousel

2022 Week 52 | Power BI: Image Carousel

Introduction “Hot days, warm nights, beaches, backyard cricket and Christmas celebrations are all part of summer in the Southern Hemisphere.” This week we will be connecting to a public flickr photo gallery from the State Library of South Australia, to create an image carousel using a custom visual from AppSource. Requirements Power Query Connect to the …

2022 Week 52 | Power BI: Image Carousel Read More

2022 Week 51 | Titles of Christmas Movies

Introduction Me and my family love sitting down and watching Christmas movies during the holiday season! In this challenge we are going to be breaking down the words used in Christmas movie titles. Check out the word cloud that we are going to be creating below! Requirements Power Query In order to get this data …

2022 Week 51 | Titles of Christmas Movies Read More

2022 Week 49 | Power BI: Build a Holiday Song Picker

Introduction Welcome back to Workout Wednesday 2022! This week we’re continuing our work with images and building a fun Holiday Song Picker using the Image Grid custom visual in Power BI! We’ll use data from Spotify to help select a song based on Artist, Tempo, or Key. If you’d like to follow along with the …

2022 Week 49 | Power BI: Build a Holiday Song Picker Read More

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 …

2022 Week 48 | Power BI: Conditional SVG Measures Read More

Scroll to Top