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 […]
2024 Week 03 – Double bar amount by accounts Read More »
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
2023 Week 41 | Power BI: 3D Scatter Read More »
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
2023 Week 33 | Power BI: Date Slicer Read More »
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
2023 Week 11 | Power BI: Determining trend with LINEST Read More »
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
2023 Week 07 | Power BI: Non-linear Regression Read More »
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
2023 Week 03 | Power BI: Vertical Area Chart Read More »
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
2022 Week 52 | Power BI: Image Carousel Read More »
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.
2022 Week 46 | Power BI: My Second Deneb Read More »
Introduction Another Deneb visual this week – creating a custom Ribbon Chart. This ribbon chart takes on a slightly different form than the ribbon charts you may be used to. This ribbon chart is focused on highlighting the change in rank and proportion of response types between the first and last dates of a
2022 Week 45 | Power BI: Ribbon Chart (Advanced) Read More »
