-
Dynamically Displaying Earliest, Latest, and Growth Over Time with a Year Slicer
This article provides a guide on marking the earliest and latest selected years on a line chart and visualizing growth over time with reference lines. Foreword Using World Bank Open Data on South American population, this case study dynamically displays urban and total population growth for the earliest and latest selected years on a line…
-
Building Tornado (Butterfly) Chart
This article will guide you how to create tornado chart, also known as tornado diagram or butterfly chart, in Power BI using entirely native visuals. What is Tornado Chart? A tornado chart (also known as a butterfly chart or divergent chart) is a type of bar chart that compares two data sets side by side.…
-
Visualizing MoM Change with the Piano Chart
This article provides a step-by-step guide to replicating the “Piano” or “Delta” chart, a creative visualization for showing changes between two points in time, within Power BI. This chart, originally created in Tableau by Guido Jongbloed, is particularly effective for emphasizing percentage changes between months. Limitations Several DAX workarounds are necessary to improve the visualization’s…
-
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.
Incorporating data storytelling into Power BI Core Visuals 