Introduction Calculation Groups in Power BI essentially allow you to apply logic or formatting to a variety of measures at the same time. For example, let’s say you were looking to create a Month-To-Date, Quarter-To-Date, and Year-To-Date view across Revenue, Orders, and Units. This would require you to create a calculation for each of the […]
2022 Week 34 | Power BI: Calculation Groups Read More »
Introduction Welcome back to Workout Wednesday! This week we’re visualizing two series of values in a take on last week’s Tableau challenge! This week’s challenge uses youth cellphone data and gives you the opportunity to either build a dumbbell chart using Charticulator or to build a lipstick column chart using a custom visual. Complete one or both
2022 Week 33 | Power BI: Compare two series of values Read More »
Introduction My name is Spencer Hamilton, Analytics Consultant with phData, and I’ll be guest hosting this week’s challenge! For the challenge, we’re going to look at one of Power BI’s newer features, Field Parameters, and create some calculations that dynamically change based on the selected parameter value. In this specific example we’re looking at Sample
2022 Week 32 | Leverage Field Parameters in Measures Read More »
Introduction This week for Workout Wednesday we are getting familiar with the PlotlyJS visual by creating traces and annotations for a connected scatterplot. Connected scatterplots are a cross between a scatterplot and a lineplot whereby two numeric variables are connected by a third ordered variable (often time). The below graph created with the
2022 Week 31 | Power BI: Connected Scatter with PlotlyJS Read More »
Introduction In Power BI, you are able to create mobile views for every desktop report. This is especially useful if you have users access the reports through the Power BI app on an iOS or Android device. This week’s challenge is to develop a mobile view of the Covid-19 tracking sample for US state and
2022 Week 30 | Power BI: Creating a Mobile View Read More »
Introduction This week, we are taking a look at a lesser used visualization type called a stream graph. Stream graphs are similar to a stacked area chart, but they have values displaced around a central axis rather than stacking on top of an axis. They have received criticism in the past for being difficult to
2022 Week 29 | Create a Stream Graph Read More »
Introduction Welcome back to Workout Wednesday! If you’re joining us for the first time, welcome! We present you with a challenge, a dataset to recreate the challenge, and a solution video or file. You can use these challenges to build your skills and your portfolio! This week we’re exploring the error bars feature in Power
2022 Week 28 | Power BI: Error Bars Read More »
Introduction If you weren’t aware, June was Music Month and Kerry Kolosko gave us a brilliant visualization of Beatles tunes using Charticulator – you can check out the challenge here. This week we are going to be recreating a recent Tableau challenge from Sean Miller that was featured in Week 11 of this year’s Tableau
2022 Week 27 | Power BI: Navigating Hierarchies Read More »
Introduction June is Music Month and this week we are getting arty with Charticulator. In our previous Charticulator challenges, we designed with cartesian plots, spiral plots and tried our hand at nested charts. For this challenge we use a Polar Scaffold to visualise songs segments by time/duration. This challenge presumes some Power Query experience.
2022 Week 26 | Power BI: Polar Plots with Charticulator Read More »
Introduction June is still music month, so for this week’s challenge we’re going to visualize music. Sometimes the simple visualizations tell the best stories. That is definitely the case for the “warming stripes” visualization which was used to show the change of global temperature over time. Using this as motivation, what if we created a
2022 Week 25 | Power BI: Visualizing Music Read More »
