Power BI Drill Down Combo Bar PRO visual for Power BI

IT & T

Audit / Accounting

Banking & Finance

Retail

Government / Institutions

Food / Beverages

Oil / Energy

Automotive

Combo Bar interactions

See all the possible ways you can explore this visual

Use cases

Drill Down Combo PRO is best suited for numerical data such as percentage, money, or units sold.

Accounting

Analyze your revenue, expenses, and profits, and see if they meet your targets.

Human Resources

Keep tabs on your staff, monitor their efficiency and track their overtime, vacations, sick days and more.

Manufacturing

Track the total amount of produced units, compare it against your targets, and determine your defect rate.

Sales

Compare the sales performance across your entire product range and measure it against your KPIs.

Key features

Multiple chart types

Pack a large amount of information in a single chart with bars, areas, and lines. Mix and match these elements to tell a story with your data.

Full customization

Create eye-catching charts that stand out. With the wide range of formatting options, you can customize any element of the chart, including colors, background, labels, tooltips and more.

Stacks & clusters

Combine multiple series in a single bar or area. Furthermore, you can create single or multiple stacks of bars and areas, and choose between normal, 100% or zero-based stacking.

Thresholds

Set up to four static or dynamic thresholds to easily see how your data compares to KPIs, sales targets or benchmarks.

Conditional formatting

Apply custom formatting settings automatically if certain conditions are met. For example, you can automatically mark the bars red if they don’t meet the threshold, or color them gradually based on the lowest or highest values. What’s more, you can even reference values from other series.

On-chart interactions

Click or tap on any of the series to drill down and zoom in to see your data in more detail. Furthermore, with cross-chart filtering you can create truly interactive reports that will make it easy to explore relevant data across multiple charts without the need of any slicers.

No-data policy

Choose what your chart does with the points that contain no data. Join will connect the line or area between the nearest points with data, Zero will show the field as a zero value, but Skip will simply show nothing at all.

Bookmark support

Save your users' time by creating convenient buttons that will display exactly the data you want them to see. Simply bookmark a view and it will be accessible with a single click.

Find out more about ZoomCharts

We frequently release informational materials to help our clients

Everything You Need To Know About Power BI Bar Charts

It is likely that, before hearing about Power BI, almost everyone’s first encounter with a bar chart happened all the way back in pre-school. After all

Read the Article

Using Power BI Conditional Formatting in ZoomCharts Drill Down Visuals

When you’re creating reports in Power BI, conditional formatting is one of the most powerful tools for data storytelling. Color is one of the main factors in visual salience, and you can use it to make your reports give a lot of information to the viewer with just a quick glance.

Read the Article

Power BI Drill Down: The Ultimate Guide

In this article, we’ll explain what are drill downs in Power BI, and give you some tips and practical examples on how to correctly implement them and make your reports more interactive.

Read the Article

Frequently asked questions

There are two main ways you can stack series, depending on your use case:

1. You only want to stack some of the series or create multiple stacks. Once All series is enabled, you will find a separate customization tab under formatting options called Series X Configuration. In this tab, you will find a setting called Stack. By default, each series has its own stack number (e.g., Series 1 = stack 1, Series 2 = stack 2 etc.). To create a stack, make sure that all the series you want to stack have the same stack number.

2. You want to stack all Series into a single stack – Once you've added all the series to the visual, go to Formatting Options > Enable. Then open `Series Default` > change the 1st setting Display from Clustered to Stacked.

Once you have created the stack, go to Formatting Options and enable Value Labels for the series at the top (last series in the stack). To do this, open Series Configuration and enable Customize This Series. Then enable Customize Series Value Labels and a new settings tab will be added to the list. Then open Series Value Labels and make sure that Use Total Stack Value has been set to Auto or True.

Once you have created the stack, go to Formatting options > Stack Settings > Mode – and change this from Normal to Zero Based. The available options are: Normal, 100% Stacked, Zero Based.

Of course! Simply go to Formatting Options > enable `Series Defaults`. Here you will see a list of properties that can be customized for all series. Remember, the settings applied here will not take effect on series for which individual series customization has been enabled. This allows you to have the full flexibility of customizing groups or individual series, and create unique chart variations.

Currently, only drill down capabilities are available for Drill Down Combo Bar PRO. The rest of these interactions will be added with future updates.

Sure, simply use Drill Down Combo Pro visual instead of the Drill Down Combo Bar PRO to achieve the wanted result. The transition is seamless - all you need to do is add the visual to the report > Select the visual on the report canvas > Click on the Combo visual icon and it will be changed to the other visual

Everything You Need To Know About Power BI Bar Charts

Using Power BI Conditional Formatting in ZoomCharts Drill Down Visuals

Power BI Drill Down: The Ultimate Guide

Want to increase report usage in your company?

Drill Down Combo Bar PRO for Microsoft Power BI

Combo Bar interactions