-
Alternative Approach to Visualize Surplus and Deficit
This article discusses alternative visualizations of surplus and deficit using clustered column charts, with a focus on the variance between actual and target profit. In a previous post, I explained how to visualize surplus and deficit amounts with stacked column charts. This post explores a different approach using clustered column charts. It compares monthly actual…
-
Highlighting Specific Categories in Multi-Line Charts
Selective highlighting is an effective technique when visualizing multiple categories. Audiences can feel overwhelmed when viewing charts with too many distinctly colored categories. This article focuses on how to implement selective highlighting in multi-line charts. What is a Field Parameter? The field parameter in Power BI is a feature that allows you to create dynamic…
-
Highlighting Specific Values in a Line/Area Chart
Key values (first, last, minimum, and maximum) are highlighted in a line chart using data labels and error bars to identify periods of missing data throughout the years.
-
Visualizing Monthly KPIs Using the JFMAMJJASOND Calendar Format
This article guides you through creating visually-appealing monthly metrics reports in Power BI by converting month names to abbreviations for a cleaner look. Foreword Dashboard design requires careful consideration of visual elements. For example, text length can significantly impact the size and layout of visuals, potentially requiring additional space and reducing valuable white space. One…
-
Simple Tricks to Build a Vertical Lollipop and Dumbbell Charts
Using line chart markers and error bars, lollipop and dumbbell plots are constructed to visually highlight whether actual values exceed or fall below the target using conditional formatting.
-
Creating Dynamic Slope Graph with % YoY Label
Constructed using two DAX measures and an additional measure for conditional formatting, this dynamic slope graph responds to slicer selections.
Incorporating data storytelling into Power BI Core Visuals 