Introduction This week’s challenge uses a few layering techniques in the Deneb custom visual. Here you will be challenged to use multiple independent scales on a layered plot. Advanced users can concatenate total bars for extra credit! Requirements Power Query Obtain the dataset from Github Model and load data Power BI Desktop Obtain Deneb from …
Introduction The November 2023 release of Power BI Desktop includes the new button slicer visual. This visual can currently be used as a replacement for the original slicer visual when using tiles. There are more enhancements to come, but we already have a lot more control over the formatting of the slicer. We can add …
2023 Week 47 | Power BI: Use the New Button Slicer Read More
Introduction This week for Workout Wednesday we are performing RFM (recency, frequency and monetary value) analysis. RFM Analysis is a marketing technique used to quantitatively rank and group customers based on the recency, frequency and monetary total of their recent transactions. A score of 1 to 5 is assigned for each of the three main factors. …
Introduction Welcome back to Workout Wednesday! This week we’re creating a dumbbell chart to compare 2 sets of values using Deneb! If this is your first time using Deneb I highly recommend you play around with either the Vega or Vega-lite languages in the online editor, where you can load the code from examples, amend it, …
2023 Week 45 | Power BI: Create a dumbbell chart with Deneb Read More
Introduction For this week’s challenge, we will be creating dynamic text boxes to introduce our visuals and tell a story around our data. This is differentiated from the “smart narrative” visual in that we will customize the text and measures that we display to create our own narrative. In the example below, you’ll notice that …
Introduction This week’s challenge looks at two options for making faceted charts with multiple measures: the Deneb custom visual and the Stacked Bar Chart core visual. The charts compare two different measures across two attributes. You’ll have to get a little creative to accomplish this in both chart types. Requirements Get the sample dataset from …
2023 Week 43 | Power BI: Faceted Stacked Bar Chart Comparison Read More
Introduction Welcome back to Workout Wednesday! This week we’re adding value to tables using SVG images! I was inspired by Sean Miller’s Week 16 Tableau challenge, and thought we could re-create this in Power BI. In this challenge, you’ll use various techniques to enhance the presentation of data within your Power BI table visual. These techniques include utilizing …
2023 Week 42 | Power BI: Add value to tables with SVGs 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 …
Introduction Last week’s workout caused some healthy discussion about bar chart labeling preferences and best practices. This week we will look at other ways to implement space saving labels while also showing the data labels for the each bar in a bar chart. The report shown below demonstrates 4 ways to implement bar chart labels …
Introduction This week we’re revisiting Meagan’s challenge where we built a bar chart with long labels. We’re going to use a trick recently unveiled by Bas (@howtopowerbi on Twitter) to create custom labels for bar charts. If you have long labels in your bar chart, they may be truncated depending on the size of the …
