Workout Wednesday

2024 Week 22 | Power BI: Approximate Binned Mapping with Scatterplots

Power BI, Workout Wednesday / By

Introduction When used with care, scatterplots can be used to create symbol maps using an equidistant projected map (or Geographic or Plate Carrée) as the plot background image. Attention will need to be paid to proportions and axis scales. More information on projection types. https://en.wikipedia.org/wiki/List_of_map_projections Requirements Obtain the snowfall data from github Create new columns …

2024 Week 22 | Power BI: Approximate Binned Mapping with Scatterplots Read More

#WOW2024 | Week 22 | Can You Make a Page Navigator?

Tableau, Workout Wednesday / By

Introduction Have you ever been frustrated with unsynchronized scrollbars when placing multiple sheets on a Tableau dashboard? I own a blog about Tableau and can tell you that one of the most frequently viewed posts is about this topic.Ken’s blog post offers several solutions to this issue. A “simple” solution is to combine everything into …

#WOW2024 | Week 22 | Can You Make a Page Navigator? Read More

2024 Week 21 | Power BI: Use Slicers to Filter a Visual Based Upon a Measure

Power BI, Workout Wednesday / By

Introduction While you can’t directly populate a slicer with a measure, you can use a slicer to filter other visuals based upon measure amounts. That is what we are doing in this week’s challenge. In the report below, we have a budget analysis report. The report allows users to filter the projects table to projects …

2024 Week 21 | Power BI: Use Slicers to Filter a Visual Based Upon a Measure Read More

2024 Week 21 | Sigma: Can you set some boundaries?

Sigma, Workout Wednesday / By

Introduction This week, I was inspired by a post in the Sigma Community from Mark Ruesink that showed a really clever way to visualize outliers in Sigma using a combo chart and some clever calculations. Mark goes all the way to visualizing outliers, so I definitely recommend checking out his full post, but I wanted …

2024 Week 21 | Sigma: Can you set some boundaries? Read More

2024 Week 20 | Sigma: Can you create quadrants?

Sigma, Workout Wednesday / By

Introduction Week 20 already! Crazy how fast the year is going by…and how fast you’re skilling up in Sigma! I love scatter plots. They’re a great way to display a lot of information in an easily consumable package. Layering quadrant colors on top, make it even easier to visually group dots and find outliers.  -Katrina …

2024 Week 20 | Sigma: Can you create quadrants? Read More

#WOW2024 | Week 20 | Can you combine categorical and sequential colors in the same chart?

Tableau, Workout Wednesday / By

Introduction A couple weeks ago while standing in line for Ken and Kevin Flerlage’s session at Tableau Conference, I had a conversation with the woman next to me that led to something like “what is something you’re trying to solve right now?” Her response was that her boss wanted to have something of a stoplight …

#WOW2024 | Week 20 | Can you combine categorical and sequential colors in the same chart? Read More

2024 Week 20 | Power BI: Build your first report with Dynamics 365 Business Central Data

2 Comments / Power BI, Workout Wednesday / By

Introduction Welcome back to Workout Wednesday! This week’s challenge is for participants new to Power BI and/or new to data visualization. We’re building a report containing 2 charts, a table, and a slicer. My challenge to you is to design the report in a way that a) makes sense to business users and b) is …

2024 Week 20 | Power BI: Build your first report with Dynamics 365 Business Central Data Read More

Radial Plots

2024 Week 19 | Power BI: Radial Plots using Line and Scatter Charts with trig functions

Power BI, Workout Wednesday / By

Introduction In this week’s challenge, we are experimenting with Radial Plots using Line and Scatter Core Visuals. Radial Lollipop charts are an alternative to radar charts. Power BI does not have Polar Plots, only cartesian plots, so we will need to use trigonomic functions within DAX to calculate the cartesian X and Y position of points. Requirements …

2024 Week 19 | Power BI: Radial Plots using Line and Scatter Charts with trig functions Read More

Scroll to Top