Power BI

2024 Week 50 | Power BI: Happy Holidays! Embed a video in a Power BI report

Introduction Welcome back to Workout Wednesday! This week we’re wishing everyone a very happy holiday season. Join us as we celebrate with a straightforward challenge, embedding a video in a Power BI report using the HTML Content custom visual.  Requirements Create a custom image that you’ll use as your landing page. Create a custom video that you’d […]

2024 Week 50 | Power BI: Happy Holidays! Embed a video in a Power BI report Read More »

Power BI, Workout Wednesday

2024 Week 49 | Power BI: Visualize Ranges with Percentiles

Introduction A percentile is a number denoting the position of a data point within a numeric dataset by indicating the percentage of the data points with an equal or lesser (assuming it’s inclusive) value. Percentiles can be used to understand test scores, stock values, health indicators, and other values. This week, we will use them to look

2024 Week 49 | Power BI: Visualize Ranges with Percentiles Read More »

Power BI, Workout Wednesday

2024 Week 48 | Power BI: Use a Calendar as a Filter

Introduction Welcome back to Workout Wednesday! I’ve been getting so much of my inspiration from the community lately, and this week’s challenge is no exception! Recently, Andy Kriebel posted a cool calendar filter on LinkedIn, that he built using Tableau. Our very own guest contributor and friend Erik Svensen took Andy’s post and re-created it

2024 Week 48 | Power BI: Use a Calendar as a Filter Read More »

Power BI, Workout Wednesday
Animated button

2024 Week 47 | Power BI: HTML & CSS

Introduction This week’s visualization is inspired by the concept of rules – understanding them and knowing how to bend them (but never break them!) At a high level, Power BI visualizations are rendered using a combination of JavaScript, HTML, and CSS in a web browser. By learning the foundational aspects of various data visualization tools,

2024 Week 47 | Power BI: HTML & CSS Read More »

Power BI, Workout Wednesday
bubble likert

2024 Week 46 | Power BI: Likert Bubble

Introduction Utilising the dataset from a previous challenge (week 43), this week we are going to build a bubble likert chart. Likerts are usually ordered categorical data, and often it does not make sense to convert categories to a numerical  score to find averages. Sometimes, likerts can be treated as interval data. https://www.scribbr.com/methodology/likert-scale/. For the

2024 Week 46 | Power BI: Likert Bubble Read More »

Power BI, Workout Wednesday

2024 Week 44 | Power BI: Community Appreciation – SQLJason

Introduction Welcome back to Workout Wednesday! I’m nearing the end of my 4th year contributing to this incredible initiative, and quite honestly, I am running out of ideas! This week I went to the Fabric Data Stories Gallery to look at reports that have inspired me, and I was reminded of this incredible report that Jason Thomas

2024 Week 44 | Power BI: Community Appreciation – SQLJason Read More »

Power BI, Workout Wednesday
Chart Makeover

2024 Week 43 | Power BI: Line Chart Makeover

Introduction This week’s challenge is to test your data storytelling skills and enhance a line chart of service desk survey responses to focus attention on important aspects. No solution file provided this week. Requirements Obtain the data Model Data Create a chart showing survey response trends Dataset This week’s dataset is downloadable from Github https://github.com/kolky001/Workout-Wednesday-2023/blob/main/Help%20Desk.xlsx 

2024 Week 43 | Power BI: Line Chart Makeover Read More »

Power BI, Workout Wednesday
scatterplot

2024 Week 42 | Power BI: Scatter Plot Dynamic Colour Density

Introduction Scatterplots are one of the most useful visual chart types for data exploration. You can use them to identify relationships among two or more variables, find clusters of data, encode data in several ways for communicating insights etc. This is especially useful when working with large datasets. In this WoW challenge, our goal is to use marker

2024 Week 42 | Power BI: Scatter Plot Dynamic Colour Density Read More »

Power BI, Workout Wednesday

2024 Week 41 | Power BI: Visualize a Drag Race with Animation

Introduction There are a few ways to visualize movement in Power BI. This week, we are visualizing race cars moving on a track. The example report below uses Deneb, but you could also complete this challenge by combining a custom visual and the Play Axis visual.  In the report below, once you click the Go

2024 Week 41 | Power BI: Visualize a Drag Race with Animation Read More »

Power BI, Workout Wednesday