Introduction Last week, our team was faced with an unique challenge and I’m using it as the basis for this week’s challenge! The premise is quite simple – create a dashboard that shows KPIs and a trend of the selected kpi. Allow the user to filter dates, change the period type and select a period …
Introduction This week, we’re building on Shannon’s theme from Week 17 2022 by creating a custom Power BI theme–with a twist! Instead of manually selecting colors, this week you’ll use OpenAI’s free version of ChatGPT (or your Large Language Model (LLM) of choice) to create a theme. You’re in control of your prompts, and …
2023 Week 21 | Power BI: Create a Theme – With a Twist! Read More
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
