3AG Systems – Column Chart With Small Multiples

Produces multiple overlapped column charts for each element in the group

Column Chart with Small Multiples compares two scenarios and displays overlapped column charts. The chart produces decomposition of each element in the group section. The visualization is meant for showing Actual, Forecast, Planned, and Previous Year data across different categories (for example departments, regions, products etc.). Formatting for the charts is influenced by the International Business Communication Standards (IBCS).

Customization options include resizing the data label font sizes, hiding data labels, adjusting the number of charts per row, adjusting units (to thousands-K, Millions-M, Billions-B) and more.

This visualization is ideal for comparing “Actual vs. Planned”, “Actual vs. Previous Year”, “Forecast vs. Planned”, and “Forecast vs. Previous Year”. Useful for displaying or monitoring grouped or time series data relative to a certain benchmark.

Add-in capabilities

When this add-in is used, it

  • Can read and make changes to your document
  • Can send data over the Internet
Membership

***** Related Blog Posts *****
Creating Multi Threaded Dynamic Visuals – Advanced Power BI Technique
Custom Dynamic Segmentation Using DAX In Power BI

***** Related Video Tutorials *****
Create Dynamic Visuals Based On Ranking in Power BI w/DAX

Outlier Detection & Visualization in Power BI – Advanced DAX
How To Use Virtual Tables With COUNTROWS in Power BI – DAX Formula Technique
RANKX Considerations – Power BI & DAX Formula Concepts
Manufacturing Operations – Power BI Showcase

Center of Excellence

***** Related Course Modules *****
Ultimate Beginners Guide to Power BI
Power BI Super Users Workshop
Solving Analytical Scenarios w/ Power BI & DAX
Advanced Analytics in Power BI
Financial Reporting w/ Power BI
Power BI Showcases

***** Related Support Forum Posts*****
Custom Visual AppStore
Custom Visuals vs Standard Visuals
Power BI – Creativity