Free 30-Days trial for xViz visuals here!

/

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!

create-stacked-area-charts-power-bi-dashboards
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:

create-stacked-area-charts-power-bi-dashboards
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.

create-stacked-area-charts-power-bi-dashboards
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

xViz
About xViz!
xViz is a leading provider of advanced enterprise-grade visuals for Microsoft Power BI. The powerful, intuitive, and customizable data visualization experience of xViz, maximizes the potential of the data and elevates analysis to new heights. This product is developed by Lumel Technologies (formerly Visual BI), which has a decade of experience in building add-on solutions on top of BI platforms (SAP BI and Power BI) with our suite of innovative products such as Inforiver, xViz and ValQ.
PBI Certified

Headquarters

5920 Windhaven Pkwy
Plano TX 75093

Inforiver
ValQ
cross linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram