-
Maintaining Visual Alignment in Matrix-Chart Combinations
This article will walk you through the process of creating a combined visualization using a matrix and bar/column charts, ensuring they remain visually aligned regardless of filtering. Use Cases Heatmaps provide a clear visual representation of data using color gradients. The intensity of the color corresponds to the data value, with warmer hues for higher…
-
Constructing Effective Horizontal Dumbbell Plots
In a previous article, we discussed creating vertical dumbbell plots using line markers and error bars. This article demonstrates how to create horizontal dumbbell plots using bar charts and error bars. Credit to Bas Dohmen for the video tutorial. Use Cases Dumbbell plots (also called connected dot plots or barbell charts) are great for showing…
-
Visualizing Variance Alongside Bar Charts
This article demonstrates how to create additional lollipop charts alongside bar charts to visualize year-over-year variance, a technique inspired by Bas Dohmen. Use Case and Limitation Bar charts effectively visualize data for comparisons between distinct categories. This case study uses bar charts to compare sales and profits across sub-categories, supplemented by variance lollipop plots to…
-
Visualizing Surplus and Deficit Using Stacked Column Chart
Surplus and deficit are visualized using a combination of line and stacked column charts. Data labels, displayed via a reference y-axis line and positioned above the columns, highlight the variance—the difference between actual values and the target.
Incorporating data storytelling into Power BI Core Visuals 