Free 30-Days trial for xViz visuals here!

Multiple Axes Chart for Power BI

Anoovendhan Subramanian
August 9, 2019

Note: This blog addresses some features of the custom visual that will be available in the App Source in Sep 2019. To get this latest build, reach out to us here.

This blog is a part of the Multi Axes Blog Series.

Use Case for Multi Axes Chart

When you deal with data of different granularities, e.g. Revenue (in millions), Average Price (say, approx. $1000) and Profit Margin (in %), it’s not possible to fit them in one or even two axes. Cases such as these call for a Multiple Axis Chart.

Let’s take a quick look at some of the key features of the Multiple Axes Chart custom visual for Microsoft Power BI

Key Features- Summary

  1. Ability to select multiple Y axes
  2. Choice of Several Series types
  3. Conditional Formatting
  4. Conditional Formatting Legend
  5. Lasso & Reverse Lasso Selection
  6. Show additional series in Tooltip
  7. Plot Lines, Bands, Standard Deviations & more
  8. Customize # of Data Series displayed
  9. Series Pattern and Color

Key Features – Description

  1. Ability to select Multiple Y-Axes
    The Multiple Axes Chart that comes with the xViz enterprise suite gives you the ability to have up to 5 axes. An example with three axes is shown below.
Multiple Axes Chart for Power BI

2. Choice of Several Series types
The Multiple Axes chart provides 10 options for choosing series such as line, column, area, spline, stacked column, stacked area, etc.

Multiple Axes Chart for Power BI

3. Conditional Formatting
The excel-like Conditional Formatting option allows you to highlight data that meets specific conditions.To create conditional formatting rules, select the icon that opens the advanced editor. In this example below, we have created a conditional formatting on ”Sales (Dollars)” series based on a rule that takes into account the value of ”State Bottle Retail Costs”.

Multiple Axes Chart for Power BI

Once you save this rule, you’ll be able to see the all the categories whose Bottle Retail cost is greater than $20 highlighted in green.

Multiple Axes Chart for Power BI

4. Conditional Formatting Legend
This option allows you to display active conditional formatting rules as part of the legend. The user can turn on/off each rule by just clicking on the legend.In the above screenshot, you can see the rule Bottle retail > 20 along with the other members of the legend and once you click on it, the rule will be disabled.

Multiple Axes Chart for Power BI

5. Lasso & Reverse Lasso Selection
It allows the user perform include/exclude filter actions.

Multiple Axes Chart for Power BI

Note:Lasso & Reverse Lasso selection are not available in the Power BI Desktop. They can be accessible only through the Power BI service.

6. Show Additional Series in Tooltip
Sometimes when you display Revenue vs. Expenses, you may also want to get an idea about a third value (such as ‘No. Of customers’). However you may not want to plot them explicitly in the chart.

For cases like this, assign this category ‘# of customers’ to the Tooltip field property, and you would be able to acccess these values in the tooltip.In the example shown below, the chart only plots Category and Sale Dollars, while the avg. Bottle cost is also available in the tooltip.

Multiple Axes Chart for Power BI

7. Plot Lines, Bands, Standard Deviations & more

The xViz mutliple axes chart allows you to plot static reference lines & bands to track performance against set benchmarks.

Multiple Axes Chart for Power BI
Multiple Axes Chart for Power BI

Similarly, you can also track standard deviations. The following visual displays 0.5 standard deviation from the mean for the data provided.

Multiple Axes Chart for Power BI

8. Customize # of data series displayed
You can also set the # of data series displayed in a custom visual by default. For example, the following chart shows 10 data series at a time, with the rest accessible through the scroll bar at the bottom.

Multiple Axes Chart for Power BI

9. Series Pattern and colors
Colors and Patterns can be added to the custom visual to make it more visually appealing.

Multiple Axes Chart for Power BI

We have covered the key features of xViz Multiple Axes Chart so far but there is more.

***

To get the latest version of the custom visual, reach out to us today here.

You can take a look at the other advanced custom visuals by xViz 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, #130
Plano TX 75093

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