Power BI

2024 Week 21 | Power BI: Use Slicers to Filter a Visual Based Upon a Measure

Introduction While you can’t directly populate a slicer with a measure, you can use a slicer to filter other visuals based upon measure amounts. That is what we are doing in this week’s challenge. In the report below, we have a budget analysis report. The report allows users to filter the projects table to projects …

2024 Week 21 | Power BI: Use Slicers to Filter a Visual Based Upon a Measure Read More

2024 Week 20 | Power BI: Build your first report with Dynamics 365 Business Central Data

Introduction Welcome back to Workout Wednesday! This week’s challenge is for participants new to Power BI and/or new to data visualization. We’re building a report containing 2 charts, a table, and a slicer. My challenge to you is to design the report in a way that a) makes sense to business users and b) is …

2024 Week 20 | Power BI: Build your first report with Dynamics 365 Business Central Data Read More

Radial Plots

2024 Week 19 | Power BI: Radial Plots using Line and Scatter Charts with trig functions

Introduction In this week’s challenge, we are experimenting with Radial Plots using Line and Scatter Core Visuals. Radial Lollipop charts are an alternative to radar charts. Power BI does not have Polar Plots, only cartesian plots, so we will need to use trigonomic functions within DAX to calculate the cartesian X and Y position of points. Requirements …

2024 Week 19 | Power BI: Radial Plots using Line and Scatter Charts with trig functions Read More

2024 Week 18 | Power BI: Visualize Mammal Lifespan with a Scatterplot and Background Image

Introduction Continuing on last week’s infographic theme, we are recreating an infographic from Visual Capitalist this week, this time showing average lifespan for different mammals.  We will be using a scatterplot visual of your choice this week. I made two demo versions, one using the Deneb custom visual and one using the Enhanced Scatterplot custom …

2024 Week 18 | Power BI: Visualize Mammal Lifespan with a Scatterplot and Background Image Read More

2024 Week 17 | Power BI: Design an Earth Day Infographic

Introduction Welcome back to Workout Wednesday! This week we’re celebrating Earth Day (April 22) with a design challenge. You can do whatever your designer heart desires with this challenge. I’ve provided a sample, but this is just to get your creative juices flowing. Whatever you do, ensure that your design is accessible and that you’re …

2024 Week 17 | Power BI: Design an Earth Day Infographic Read More

Star Trek timeline data plotted on a sine wave

2024 Week 16 | Power BI: Timeline on a Sine Wave with Core Visuals

Introduction In this week’s challenge, we are creating a timeline visual on a sine wave. You can use your creativity to break out the timelines into series, through conditional formatting, offsetting separate shapes, or create different shapes using different trigonomic functions. Alternatively, with small multiples. Requirements Obtain the data from Kaggle and/or Wikipedia Create a …

2024 Week 16 | Power BI: Timeline on a Sine Wave with Core Visuals Read More

2024 Week 15 | Power BI: Visualize sunrise times with a line chart

Introduction Since I watched the solar eclipse from Texas this week, we have a solar theme. We are visualizing the sunrise time each day in 2024 to date. I’m keeping it simple with the line chart core visual, but you can use whatever visual you would like.  Requirements 1. Retrieve the data from Data.World.  2. …

2024 Week 15 | Power BI: Visualize sunrise times with a line chart Read More

2024 Week 14 | Power BI: Use a matrix to re-create a Tableau viz

Introduction Welcome back to Workout Wednesday! This week we’re recreating a really neat viz that was originally created by Flávio Matos for the Tableau team back in 2023. Flavio created the Periodic Table of Wine, with an option for users to select the food they’ll be eating to help them pair the perfect wine. Today, …

2024 Week 14 | Power BI: Use a matrix to re-create a Tableau viz Read More

Overlapping Histogram

2024 Week 13 | Power BI: Overlapping Histogram

Introduction In this week’s challenge we are creating an Overlay Histogram. An overlay histogram utilises overlapping columns or bars to compare two populations. In this case, we are utilising the speed dating data from a previous challenge to compare male and female differences in dating preferences. Requirements Obtain the data from the Workout Wednesday 2022 …

2024 Week 13 | Power BI: Overlapping Histogram Read More

2024 Week 12 | Power BI: Contact Cards and Headerless Tables

Introduction This week’s challenge uses a custom visual to achieve some formatting that cannot currently (as of March 2024) be achieved using core visuals. First, we have a table that contains 2 columns and no headers. Next, we have some contact cards that contain both an image and text. The catch is that the number …

2024 Week 12 | Power BI: Contact Cards and Headerless Tables Read More

Scroll to Top