-
Applying RFM Analysis for Customer Segmentation Using Power BI
This article guides you on how to perform RFM analysis for customer segmentation in Power BI. This analysis segments customers based on their purchasing behavior by assigning scores for the recency of their last purchase, the frequency of their purchases, and their total spending. Kindly note that this article will not provide a detailed guide…
-
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…
-
Designing IBCS-Standard Small Multiple Pie Charts
The International Business Communication Standards (IBCS®) provide a set of rules for designing business reports, presentations, and dashboards to ensure clear and effective communication. Foreword Power BI’s add-ins, like Inforiver and Zebra BI, offer ready-made IBCS charts, though their advanced features require a subscription. However, creating IBCS visuals with native tools provides valuable learning experiences,…
-
Implementing Proper and Optimized Pagination
This article details a pagination technique for Power BI visuals, using field parameters and DAX measures to eliminate scrolling. Building upon Bas Dohmen’s work, this enhanced version improves loading times through optimized DAX measures for item filtering, resolves duplicate ranking issues with a secondary sorting criterion, and addresses skipped ranks with additional DAX functions. Problem…
-
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…
-
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…
Incorporating data storytelling into Power BI Core Visuals 