How to create 100% Stacked Area Charts in Power BI Dashboards

Prachi Mishra
March 9, 2022

Area charts are very useful in visualizing dense data over time. 100% Stacking is a part-to-whole representation of the area chart to focus on the contribution of different categories and across the horizontal axis like time.  The xViz Multiple Axes Chart provides a variety of data representations in up to 5 different axes. The data representation can be configured from the ‘Data Series’ option from the formatting pane in Power BI. Configurations can be done from 20+ types ranging from column, line, area, stacked, spline, and so on!

Figure 1: Data Series options to configure different data representations

Using the xViz Multiple Axes visual, one can easily configure a 100% Stacked Area chart using the Area Percentage Stacked option with just a few clicks. Here is a short video on how it can be done:

Figure 2: 100% Stacked Area Chart in Power BI using xViz Multiple Axes Chart

For example, we can derive the following insights from the above-given snapshot:

  • For the year 2014, Gift Store has the highest contribution. For the years 2013 and 2016, it has been the one of the lowest contributors to the total revenue for those respective years.
  • Corporate category has been able to keep a steady share of contribution in the revenue over the years.
  • From the year 2015, Supermarket’s share have decreased whereas that of Novelty increased.

The visual also supports the spline variation of the Area charts using the Area Percentage Stacked option to give a curvy style to the area visualization.

Figure 3: 100% Stacked Spline Area Chart in Power BI using xViz Multiple Axes Chart

Related Power BI Ideas: 100% Stacked Area Chart in Power BI


Try out the xViz Multi Axes Visual and explore all the cool features in Power BI here

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram