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 …
2023 Week 40 | Power BI: Bar chart label bonanza Read More »
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 …
2023 Week 39 | Power BI: Bar chart custom labels Read More »
Introduction The race to dominate quantum computing has the potential to revolutionise various fields by solving complex problems that are currently intractable for classical computers. This week we will recreate the infographic “The State of Quantum Computing” published in the Harvard Business Review magazine (Harvard Business Review, vol. 101, issue 2, 2023, p. 25). Requirements …
2023 Week 38 | Power BI: Visualize the State of Quantum Computing with Deneb Read More »
Introduction Sometimes it can be useful to show all data points instead of aggregating them. That is where an instance chart, also called a strip plot or a barcode plot, can be useful. A strip plot is like a single-axis scatter plot. The symbol or shape used in the instance chart can vary, but it’s …
2023 Week 35 | Power BI: Create a Faceted Instance Chart Read More »
Introduction Welcome back to Workout Wednesday! This week we’re building some basic visuals and use dynamic titles to visualize gas prices in the Rocky Mountain Region of the US (where I live!) over the past 3 years from the U.S. Energy Information Administration. Be sure you’re using the June 2023 version of Power BI desktop or later …
2023 Week 34 | Power BI: Use core visuals with dynamic titles 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 …
Introduction This week’s challenge was inspired by FiveThirtyEight’s Nobody had more style than Jay Wright created by Ryan Best For this week’s challenge we will be creating SVGs with shape elements that are coloured dynamically based on field values. Create your own SVG and add your own flair to this design. Requirements Obtain the source data …
