Introduction This week’s challenge is a slight twist on the classic Measure (bar) vs Target (gantt) chart. The key difference here is that we want to allow the user to select a ‘tolerance’ around the specific Target value. We only want to highlight months where profit was Above or Below the permited tolerance. Click to …
#WOW2023 | Week 21 | Profit vs Target (with Tolerance) Read More
Introduction For this Workout Wednesday, we are putting a Power BI spin on a Tableau viz created by Luke Stanke and Spencer Bauke for their Workout Wednesday 2023 Week 14. While we could probably match nearly exactly to the original Tableau viz by using Deneb in Power BI, I wanted to see what I could …
2023 Week 20 | Power BI: Remake of Tableau Length of Baseball Games Read More
Introduction This week, I’m introducing the idea of taking bathymetry or contour lines on maps and placing the lines on heat maps. These lines come from identifying the elevation (for contour lines) or depth of water (for bathymetry lines) and creating a map using those values. Here is an example of a contour map from …
2023 Week 20: Can you build a heat map with bathymetry lines? Read More
Introduction I’m so excited to bring this challenge to you live from Tableau Conference 2023 and I get to be the one who created the challenge. I saw something on twitter a while back and wanted to see if I could recreate it in Tableau. This challenge is not as easy as it looks but …
#WOW2023 Week 19: Can you create a jitterfly chart? TC23 Live Edition Read More
Introduction This week we are going to focus on data security and how we can ensure that only certain users see certain opportunity data! Sharing inheritance and security predicates are supported in CRM Analytics – this week we are going to look at security predicates – row-level security which enables you to model many different …
Introduction Welcome back to Workout Wednesday! We’re taking inspiration once again from our friends at Makeover Monday. This one is fun – the Makeover Monday team was inspired by a bar chart featured in a blog post and they decided to recreate it in Tableau! You can read Andy’s full post on his blog if you want more info. Today …
2023 Week 19 | Power BI: Formatted bar chart and bookmark navigator Read More
Introduction This week’s challenge is a little SVG fun. Recent Power BI Desktop changes have allowed even further width and height adjustments for images in matrix visuals. So we will be extending this by making a bar chart of chocolate bars. Requirements Power Query Obtain the dataset from 2023-week-11 challenge or; Obtain the dataset from …
Introduction One of my favorite challenges from the past is from Week 4 2020: Can you combine relative and custom dates? I was always fielding questions if I could have a relative date filter and a date picker on the same dashboard, but hadn’t ever figured it out. After Sean’s challenge that week, I implemented …
#WOW2023 Week 18: Can you combine relative and custom date filters? Read More
Introduction This week’s challenge is provided by Guest Contributor Ben Ferry aka Power BI Guy. Requirements Power Query Transform data (hint unpivot and reduce the number of columns) Load Data Power BI Desktop Create a Measure for the Sum of the values column Create a measure to rank the characters based on the measure you …
2023 Week 17 | Power BI: Peaches’ Parameters and Bowser’s Bookmarks Read More
Introduction For the last week of Community Month, I’m thrilled to introduce you to my colleague at Biztory, Nik Eveleigh (@MrEvilEye). I’ve known Nik virtually through our shared love of #WOW for around 3 years. After he returned to the UK from South Africa at the end of last year, I was delighted to learn …
