Introduction In honor of the Power BI Desktop dark mode being scheduled for public preview this month, we are making a report that allows you to switch between light mode and dark mode. Requirements Get the data from Data.World. Filter the report to the year 2024. Create a card that shows current year sales. Create …
2024 Week 37 | Power BI: Create a Report with Light and Dark Mode Read More
Introduction Welcome back to Workout Wednesday. This week we’re taking inspiration from the incredible infographics team over at the New York Times. Their 2015 article looks at the average American’s contribution to the drought in California. As of today (Sep 2024), about a third of California remains abnormally dry. This challenge features some fun data work …
2024 Week 36 | Power BI: Recreate a NYT Interactive Article Read More
Introduction Overlapping histograms with normal curve overlays are used to compare the distribution of a numerical variable across different groups such as male and female body mass. With this we can glance the central tendency, spread, and skewness of the data within each group and also how well the data follows a normal distribution. The …
2024 Week 35 | Power BI: Overlapping histogram with normal distribution curve Read More
Introduction This week’s challenge is provided by guest contributor Erik Svensen https://www.linkedin.com/company/catmansolution. The workout will use visual calculations in combination with numeric parameters to highlight a period in a development chart. (Please note visual calculations do not currently publish to web) Requirements 1. Retrieve the data from Google Sheets – (you only need orders)2. Add …
2024 Week 34 | Power BI: Visual Calcs and Parameters Read More
Introduction Editor’s note: This week we have a guest post from Imran Haq (LinkedIn, X). If you haven’t already, try out his previous WoW contribution to make a jittered column chart. The segmented bar chart from week 29, inspired some experimentation with similar designs. This week we are making segmented donut charts. These donut charts have 2 …
Introduction Welcome back to Workout Wednesday. This week we get to combine our love for data and the Olympics by building an Olympic medal tracker! This is a design challenge. I have created a sample for inspiration, but feel free to build the report in any way your creative heart desires. In this challenge you’ll …
2024 Week 32 | Power BI: Track the Olympic Medal Count! Read More
Introduction This week’s challenge is brought to you by Guest contributor Roland Szirmai. Requirements Download data from SQLBI’s blog2. Create a Sales YTD and Sales PYTD patterna. Don’t forget the ShowValueForDates calculated column and the DateWithSales measure 3. Confirm that the Sales YTD and Sales PYTD measures are correct4. Replicate the TopN vs Others measures …
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 …
Introduction This week, we are recreating a previous Tableau workout in Power BI in which we build a segmented bar chart that contains a bar for the total amount followed by a bar that shows a categorical breakdown of that amount. This challenge involves a bit of data transformation as well as some more advanced …
2024 Week 29 | Power BI: Remake of a Tableau Segmented Bar Chart Read More
Introduction Welcome back to Workout Wednesday! This week’s challenge is purely dataviz – there is no data transformation involved. A huge thanks to our friend and colleague Zoe Douglas for providing us with a beautiful and fun report to recreate. Find the data and instructions to complete the challenge below, and as always, have fun! Requirements …
2024 Week 28 | Power BI: Create custom navigation with Zoe Douglas Read More
