Introduction Sometimes it can be useful to show all data points instead of aggregating them. That is where an instance chart, also called a strip plot or a barcode plot, can be useful. This week we are building on a faceted strip plot made in 2023 week 35, and adding a median overlay. Inspired by …
2024 Week 5 | Power BI: Create a Strip Plot with Median Overlay Read More
Introduction 2024 is here! And with that, a completely new set of challenges for you, data lover. Let’s sharpen our CRMA skills with this challenge: A double bar chart displaying open and closed amounts by account. The closed amount should display won and lost amounts in a single stacked bar. The open amount should be …
Introduction This week’s challenge is a simple challenge of creating a 3D Scatter Plot with the PlotlyJS Custom Visual for Power BI. The data shows the dominant colours of Bob Ross paintings across all episodes and seasons. The colours are plotted by hue, saturation and lightness along X, Y and Z scales. You can extend …
Introduction Welcome to the Workout Wednesday Week 32! This week’s challenge will focus on how to create an advanced date slicer in the Power BI report. A user-friendly and modern-looking slicer to level up your dashboards. You can create your own designs, share them with colleagues and control the preview. To re-create, I am …
Introduction This week’s challenge uses Deneb custom visual to create a jittered scatter with inverted axis plus a bubble plot with labels. Requirements Power Query Obtain the dataset from Australian Bureau of Meteorology Website Model and load data Power BI Desktop Option 1: Obtain Deneb Custom Visual from AppSource Create a Scatter Chart with point …
2023 Week 22 | Power BI: Inverted Jittered Scatter Read More
Determining trend for use in smart narratives with DAX LINEST and Power BI
Introduction This week for Workout Wednesday we will be trying our hand at non-linear regression with the Deneb custom visual. With Vega and Vega-Lite we can create a non-linear line of best fit over our data points and utilise the statistical API to return a correlation coefficient. Requirements Power Query Obtain the dataset from the …
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 …
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 …
Introduction During week 42’s community month challenge brought to us by Thys van der Westhuizen – Thys built on my week 37 challenge – My First Deneb. For that week’s challenge I built out three basic bar charts using Deneb visuals, and subsequently, Thys continued to build a few more amazing visuals in his challenge. …
