logo
For Power BI
  • Products
    • Drill Down Donut Pro Drill Down Donut PRO
    • Drill Down Pie Pro Drill Down Pie PRO
    • Drill TimeSeries Pro Drill Down TimeSeries PRO
    • Drill Combo Pro Drill Down Combo PRO
    • Drill Map Pro Drill Down Map PRO
    • Drill Scatter Pro Drill Down Scatter PRO
    • Drill Down Network Pro Drill Down Network PRO
    • Drill Down Waterfall Pro Drill Down Waterfall PRO
    • Drill Down Graph Pro Drill Down Graph PRO
    • Drill Down Timeline Pro Drill Down Timeline PRO
    • Drill Down Combo Bar PRO Drill Down Combo Bar PRO

    Video tutorials

    Watch Now

    More than 90 videos on how to enhance Power BI with ZoomCharts

    Learn more
    All visuals
  • Resources

      Resources

    • Documentation
    • Report Examples
    • Blog
    • Webinars
    • Video Tutorials
    • Visuals Gallery

    Support

    • ZoomCharts Assistance
    • Contact Sales
    • Contact Support
    • FAQ

    Challenges

    Challenges

    Improve your report creation skills by participating in free challenges for report creators.

    Learn more
    Start trial
  • Services
    • Power BI Report Development
    • Custom Visual Development
  • Challenges
  • Pricing
Request a quote Start Free Book a Demo Sign in
Request a quote Start Free Book a Demo Sign in
Get it now
Go back

Contents

Go back

Mar 13, 2024

NEW FEATURE: Legend Field in ZoomCharts Visuals

We have added the much-requested Legend field to Combo, Combo Bar, and Timeline visuals which makes it easier to split values into visually distinct segments.

Title image
Title image

We have added the much-requested Legend field to Combo, Combo Bar, and Timeline visuals which makes it easier to split values into visually distinct segments.

Contents

Share this article

What Is The Legend Field?

The Legend field makes it faster and easier to split values into smaller segments. This field requires a column with category names which will be used to split the Series values and do the following:

  • Display separate segments as a stack or cluster, showing how each segment contributed to the total Series value.
  • Create legend items for each segment to quickly show/hide them without filtering.
  • Apply custom fill colors to each segment.
  • Show each segment value in the tooltip.

This field is available in Drill Down Combo PRO (v1.11.7.0 or later), Combo Bar PRO (v1.11.7.0 or later), and Timeline PRO (v1.11.8.0 or later). Make sure that you have updated your visuals to access the Legend field in the Visualizations pane. You can check the current version of your visuals by pressing the "?" (Info) button at the top right corner of the visual.

Comparison - No Legend field vs With Legend field

How To Use The Legend Field?

Let’s use an example. This Combo PRO column chart is created using two fields – Category (Country), and Series (Profit). Currently, we see the total profit per each country, but not much else.

Combo PRO chart without using Legend field

Let’s say that we want to see how much each of our products contributed to the total profit in each market. Our data has a text column Product that contains product names (Amarilla, Carretera, Montana, etc.) adjacent to each value. Once we drag this column to the Legend field, it will split the series values into segments that show how much profit each product earned in each country.

Combo chart after adding Legend field

Previously, you could achieve this in Drill Down Visuals by using an inconvenient workaround. You would have to define each segment as a separate series (either in data or with measures).

Legend field makes this so much quicker and easier. Simply drag a column to the Legend field, and it will instantly split values from the Series column(s), with no extra work or measures needed. This also works seamlessly with drill down, dynamically splitting data for each hierarchy level that the user visits.

You can also choose whether the separated values are displayed as a stack or cluster – go to the Series Defaults (or Series X Configuration if you wish to adjust a specific series independently) and choose the preferred mode with the Display setting. You can further customize stack or cluster behavior in the Stack Settings or Column Padding sections.

Stack vs. Cluster display mode comparison

How Would The Legend Field Work With Multiple Series?

By default, the Legend field will split all series on the chart, but you can enable or disable splitting for each specific series. To do that, we can go to the Series X Configuration section for the series you want to adjust and disable the Split by Legend toggle, so the series isn’t affected by the Legend field.

In this example, we’ll create a Timeline PRO chart with two series: Units Sold (as columns) and Profit (as lines). We want to split the Units Sold series to see which products had the highest sales, but we don’t want to split Profit so we can see the total profits as a single line. That’s why we left the Split by Legend toggle enabled for Series 1, but disabled it for Series 2.

Legend field behavior when using multiple Series

Other Benefits of The Legend Field

By default, the legends block will display each series as an item. However, when you use the Legend field, the legends block will show categories from the Legend field instead. If you’re showing multiple series, the Legend categories will be displayed separately for each series (you can exclude a series from the legends block with Show in Legend toggle in their Series X Configuration sections).

This is incredibly useful because in Drill Down Visuals, you can click on any legends block item to show or hide it from the chart. If you wish to exclude a specific subsegment from the total value and see, for example, the profit without a specific product, just click on its legend! This will simply hide the data from this visual and will not apply a filter on other visuals.

Furthermore, the tooltip will display not just the total value of the stack or cluster, but also each of the subsegments that you split using the Legend field. What’s more, it will show only values that are visible on the chart, so if you hid any subsegment by clicking the legends block items as described above, they will also not appear in the tooltip. With the tooltip, users can access more detailed insights by simply hovering over data.

Legend categories in the tooltip

Lastly, when you add data to the Legend field, a new section – Data Colors – will appear in the Format visual tab where you can assign a specific color for each legend category. These colors will be applied to any series that are split by the Legend field, overriding the default color settings or series configuration. If you wish to add a gradient effect to the colors, you can use options in the Fill Color Settings section.

Adjusting legend colors with Data Colors setting

Legend Field Use Cases

The most obvious benefit of the Legend field is how much faster and easier it is to break down a total value into smaller components. You don’t need to create calculated columns or apply measures to achieve this anymore, because Legend field splits data directly from the Series columns. It’s purely visual and makes no changes to the data itself.

Our example showed how Legend field separated the total profit into profit-per-product, but there are various other ways how report creators can use this feature. For example, you’re creating a demographics report and need to quickly separate data by age group or gender. Or you are analyzing website traffic, and you want to see how many visitors use mobile or PC, or what OS or browser versions are the most popular.

One nifty thing about the Legend field is that it is separate from the series and categories (or time units in Timeline), and it doesn’t affect the data or filters. When the user selects or drilldowns a category or series as usual, the visual will filter data and cross-filter other visuals; but showing/hiding legend subsegments will not apply a filter.

If you wish to provide a way for users to filter data by legend subsegments, simply create a slicer or a separate visual with cross-filtering (for example, Donut PRO) from the same column that you used in the Legend field. This means that you can have more control when planning the userflow and navigation of your report.

envelope icon

Want more info like this?

Subscribe to our newsletter and be the first to read our latest articles and expert data visualization tips!


Find out more

Oct 18, 2022

Blog Thumbnail
Guides

Create a Power BI Org Chart & More with Drill Down Graph PRO

Drill Down Graph PRO is one of our most advanced data visualization tools, and in this article, we will explore the many ways you can use it in your Power BI reports, including org charts, AML graphs and more. Furthermore, we will go through some tips & tricks on how to create graphs in Power BI with this powerful visual.

Jun 12, 2022

Blog Thumbnail
Guides

Power BI Waterfall Charts: A Detailed Guide

Do you know how to make a waterfall chart? Here are 7 tips you should know when building user friendly Power BI waterfall charts. Customize it to tell a data story that helps you make data driven decisions. Bar and column charts work great for visualizing a beginning and ending value. However, these charts fail to display the full data story by leaving out all the unique factors that contribute to a final net value. In this article, we will look at the basics of waterfall charts and what practices you can implement to build the best waterfall charts in Power BI.

Jul 01, 2022

Blog Thumbnail
Use cases

Microsoft Integrates ZoomCharts in Dynamics 365 Supply Chain Insights

We are excited to announce the collaboration between Microsoft’s latest product – Dynamics 365 Supply Chain Insights – and technologies provided by ZoomCharts – the Network and Map visuals.

Feb 14, 2022

Blog Thumbnail
Guides

Everything You Need To Know About Power BI Bar Charts

Power BI bar charts are a simple and efficient way to show category-based data. Almost everyone has used a bar chart, which is why they've remained incredibly popular through the years. In this article, we will explore the many ways you can make Power BI bar charts even more powerful and use them to the max.

Dec 16, 2021

Blog Thumbnail

How We Turned Many Excel Files Into an Interactive Power BI Report about Latvia’s Export landscape

How We Turned an Excel Sheet Into an Interactive Report: Latvia Export Barometer. ZoomCharts took part in a widescale project that created a full report of...

Sep 04, 2022

Blog Thumbnail
Guides

Power BI Donut Chart

The donut and pie charts are some of the most ubiquitous charts around. Instantly recognizable by people who have very little to do with charts, every report creator is bound to have to include a Power BI donut chart into a report at some point. This is not a commentary on whether you should love or hate donut charts, but rather a guide on getting the most out of donut and pie charts. Strap in tight, we're going to go over the whys, hows, do's and don'ts of Power BI donut charts.
  • «
  • 1
  • ...
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • »

Contents

Share this article

Want more info like this?

Subscribe to our newsletter and be the first to read our latest articles and expert data visualization tips!


Thank you!

Check your inbox to verify your email address.

logo
[email protected]
+44 204 577 3993
logo

Products

Drill Down Network PRO Drill Down Waterfall PRO Drill Down Graph PRO Drill Down Combo PRO Drill Down Combo Bar PRO Drill Down Donut PRO Drill Down Pie PRO Drill Down TimeSeries PRO Drill Down Timeline PRO Drill Down Map PRO Drill Down Scatter PRO All Visuals

Resources

Report Examples Webinars Blog ZoomCharts Academy Visuals Gallery Documentation Custom Visual Development Subscribe to News

Solutions

Custom Visual Development

Company

Pricing About Us Partners Leave feedback Join PowerGroup EU Funding

Help

ZoomCharts Assistance Contact Sales Contact Support FAQ

Drill Down Network PRO Drill Down Waterfall PRO Drill Down Graph PRO Drill Down Combo PRO Drill Down Combo Bar PRO Drill Down Donut PRO Drill Down Pie PRO Drill Down TimeSeries PRO Drill Down Timeline PRO Drill Down Map PRO Drill Down Scatter PRO All Visuals

Report Examples Webinars Blog ZoomCharts Academy Visuals Gallery Documentation Custom Visual Development Subscribe to News

Custom Visual Development

Pricing About Us Partners Leave feedback Join PowerGroup EU Funding

ZoomCharts Assistance Contact Sales Contact Support FAQ
+44 204 577 3993
[email protected]

Ready to get in touch?

Contact our experts with any question about Power BI and ZoomCharts for Free!

Contact us

© 2025, Data Visualization Software Lab

U.S. Patents No. 11,645,343; 11,921,804

Cookies Policy
Manage cookies
Privacy Policy
Global
EULA
Patent
warning

Error message

success

Success info: Done!

ZoomCharts AI Assistant

We noticed you're using an old OS version.

For the best experience, we recommend upgrading to ensure that all website features display correctly.

Cookie settings

We use necessary cookies for site functionality, as well as statistic, marketing, and preference cookies to enhance your experience. For more information and to manage your preferences, please visit our Cookie policy