Select Page

Latest Feature Updates to the Waterfall Chart [v1.1.5] Power BI Custom Visual

by | Sep 1, 2020 | Waterfall Chart

This blog is part of the xViz Waterfall Chart Blog Series

In this blog, we will be looking at some of the latest feature additions to the xViz Waterfall Chart v1.1.5 catering to some of the most requested use cases like only values and Stacked Waterfall Chart.

 Key Features – Summary

  1. Top ‘N’ with ‘Others’ bar
  2. Annotations
  3. Stacked waterfall chart with stacked tooltip and column totals
  4. Only Values use case
  5. Improved Axis Break experience
  6. New X-Axis label formatting options – word wrap and step like
  7. Sorting for Breakdown Analysis
  8. Deviation bar
  9. Legends support
  10. Intermediate Sum UI/ UX

Key Features – Description

  1. ‘Top N’ with Others
    Often we come across a scenario where our waterfall chart has a lot of category items to be displayed which makes the chart look cluttered and hard to read. With ranking, you can focus on the most important Top N categories and group the remaining as ‘Others’; thereby making the chart easy to understand and avoid scrolling across the axis. The ranking feature is part of the Utility Menu option and is available both at design and runtime for the end audience to make changes.
    Latest Features to Waterfall Chart Power BI Custom Visual
  2. Annotations
    Annotations are a standard feature provided across most of the xViz charts which helps enrich your storytelling experience with textual call outs and drive attention to important areas. The 2 types of annotations supported by the waterfall chart are as follows-

     

    • Datapoint– Pinpoint a data point with the ability to add any data value (Category or measures) as part of the annotation
    • Canvas – Annotations made on chart plot area/ background

    Apart from this, the xViz Annotation Feature supports different display options –

    • Text only
    • Icon Only
    • Text+ Arrow
    • All
      Latest Features to Waterfall Chart Power BI Custom Visual
  3. Stacked waterfall chart
    On popular customer requests, we have added support for the Stacked waterfall chart scenario. Thus, making it easier for a lot of MS Excel users looking for this feature to move to Power BI. To enable the stacking option, you would need a stacking dimension in Breakdown/ Stacking fields well and select Breakdown Type = Stacking under Chart options.
    Waterfall Chart Power BI Custom Visual

     

    • Column Totals – Display the Total for each bar on the top along with the data labels for each stacked item
      Waterfall Chart Power BI Custom Visual
    • Stacked Waterfall Chart tooltip Similar to the xViz Multi-Axes chart, you can also view the totals for each column along with the split up for each legend item. This makes it easier for business to understand the contribution of each of the items towards its total
      Waterfall Chart Power BI Custom Visual
  4. All Measures scenario (Only Values)
    Like MS Excel you can now create a waterfall chart with just values without needing a category field for X-Axis.
    Waterfall Chart Power BI Custom Visual

  5. Axis Break with scaling
    Axis break provides a zoomed view and makes it easier to view the variances in the waterfall chart. With the new xViz Waterfall chart 1.1.5, you now have more control over axis break where instead of having a fixed axis break option, one can customize the scale. The lower the value of the axis scale the more zoomed-in view you would have of the variances.Waterfall Chart Power BI Custom Visual
  6. X-Axis label formatting
    As feature parity with other xViz charts, two new X-axis label formatting features have been added to the Waterfall chart which is:

     

    • Stepped labels – Display Labels in Steps format to accommodate long labels
    • Word Wrap
      Waterfall Chart Power BI Custom Visual
  7. Sorting for breakdown scenario
    Along with sorting based on values and categories, the xViz Waterfall chart also provides sorting based on variance and variance % values. The sorting based on variance and variance% which was earlier restricted to only the Variance analysis use case has now been extended to breakdown scenarios as well.
    Waterfall Chart Power BI Custom Visual
  8. Deviation bar support for additional use cases
    The Deviation bar, found under the Utility Menu option helps analyze the difference between any two columns at runtime. The support for deviation bar has now been extended to all waterfall use cases except for the Stacked waterfall chart scenario.
    Waterfall Chart Power BI Custom Visual
  9. Legend support
    Legend support has been added to the xViz waterfall chart for a variety of use cases including simple waterfall, stacked scenario, and breakdown analysis use case.
    Latest Features to Waterfall Chart Power BI Custom Visual
  10. Intermediate sum enhancements
    The Intermediate Sum feature comes in handy for a variety of financial use cases where you would like to display a custom summation column between the start and end of the waterfall chart. Found under the advance editor tab, the Intermediate sum Tab has been redone for ease of use and better UX.
    Latest Features To Waterfall Chart Power BI Custom Visual

***

The xViz Waterfall Chart is a part of the xViz Pro Suite, check out all the resources for Waterfall Chart including other blogs, and FREE Power BI Desktop Version!

Check out all the Power BI Visuals in the xViz Pro Suite here

Subscribe to Our Newsletter

Related Posts

Get Started with xViz today!

Try xViz to instantly visualize the power of business optimization.