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

Nov 07, 2022

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.

Title image
Title image

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.

Contents

Share this article

Color can call attention to certain data points and help your users quickly draw conclusions, which is why conditional formatting is a useful feature for Power BI data visualization. It will automatically select the colors, gradients or other formatting options for your data depending on your chosen criteria.

In this article, we will explain in detail what Power BI conditional formatting is, how to use it in ZoomCharts Drill Down Visuals, and how to best utilize it to enhance your data storytelling within your reports.

What is Power BI conditional formatting?

When you are building charts for your report in Power BI Desktop, you will have the ability to manually apply colors and gradients to specific data series or the entire chart. You can use these formatting options to make your chart look visually appealing or fit within your brand guidelines. However, some charts may benefit from the use of specific colors to tell a narrative. One such example would be highlighting series that exceed your KPI in green, but those below it in red.

Doing this manually will get tedious, as you will have to go into the settings for each column or bar and pick a color every time. That’s where Power BI conditional formatting comes in. It’s a feature that automatically applies certain formatting rules in accordance with predefined conditions, such as percentage or numerical value.

Use cases for Power BI conditional formatting

There are many ways you can use Power BI conditional formatting to make your data more salient and readable at a glance. In ZoomCharts Drill Down Visuals, conditional formatting will automatically adjust the formatting based on a numerical value. Here are some of our ideas on how to use this convenient feature.

Use case #1 – Financial analysis

When creating a financial report, you can use conditional formatting to clearly display how your results stack up against your forecasts or expectations. This feature will come in handy whether you’re creating a timeline of your financial results or a budget breakdown. Conditional formatting will bring attention to underperforming financial quarters, or, conversely, call attention to your successes.

Conditional Formatting in Power BI financial chart

Use case #2 – KPI tracking

Whether you’re measuring the results of your marketing campaign, production output of your factories or staff productivity, there will always be some key performance indicators you can compare them against.  

KPI conditional formatting in Power BI

Set the expected amount of sales conversions, social media engagements, website visits or manufactured units as the middle point, and enable conditional formatting to automatically highlight the data series that fall below that line in a distinctive color.

Use case #3 – Benchmarking

When developing or maintaining software or hardware products, it’s important to benchmark and analyze the performance and compare it against your targets. For example, if your team is developing a new software algorithm and you need to create a chart for your benchmark results, you can set the desired performance scores as the middle point.

Power BI conditional formatting benchmark chart

With conditional formatting, the visual will automatically select the colors for each column or bar according to their score. That way, you can quickly see the status of the project and the progress made by your team.

Use case #4 – Thermal analysis

Most people subconsciously associate color red with warmth and blue with cold. So, when you’re creating a bar or column chart that includes temperature data, it’s handy when the visual can appropriately format by rules depending on the degree value.

Temperature chart in Power BI with conditional formatting

Whether you’re creating detailed weather reports or monitoring the thermal efficiency of your products or equipment, you can use Power BI conditional formatting to color-code your temperature timeline chart. What’s more, you can use stepped colors or gradients to display the intensity of heat or cold.

If you’re working with weather data, temperature is not the only measurement that will benefit from conditional formatting. You can also use it to format your precipitation, humidity and other weather data charts in a similar fashion.

How to use Power BI conditional formatting in ZoomCharts Drill Down Visuals?

Conditional formatting is a feature that has been recently introduced to Drill Down Combo PRO, Combo Bar PRO, Timeline PRO and TimeSeries PRO visuals. After you’ve created your chart, you can then adjust formatting settings and enable the conditional formatting feature. Here’s how to do it.

Step 1: Open the formatting settings

Click on the chart you want to customize, and the visualizations pane will reveal more options. You can find all the formatting options under the Format your visual tab. You’ll see a wide range of options, but to adjust the conditional formatting settings, you’ll need to scroll down and find Series X Configuration. Each of the series on your chart will have its own menu, so choose the one you want to adjust.

How to enable Power BI conditional formatting

Step 2: Apply Power BI conditional formatting

In the individual series customization menu, you can find the toggle for conditional formatting. Click on it to enable this feature, and a new set of options will be revealed. First off, you will have to choose the color origin points. They are the points around which the formatting conditions will be adjusted. You can adjust the upper, middle (optional), and bottom color origins separately.

Selecting This series will give you the choice to use average, smallest value, or percentile as the color origin. You can also manually enter a value by choosing Constant Value or reference it from Another series.

Conditional formatting settings in Power BI

Step 3: Adjust the formatting

Now that we’ve verified that the conditional formatting is enabled and it’s configured properly, we can move on to the fun part – customization! You can choose between four coloring modes. 

  • Solid H color: conditional formatting will be applied to the entire category if the criteria is met.
  • Solid V color: conditional formatting will be applied only to the part of the column, area, or line that exceeds the threshold.
  • Stepped color: the minimum and maximum values of the series (+ optionally middle point) will use the defined colors, but anything in between will use a color scale.
  • Gradient: the color origin points will form a linear gradient across the entire series.

Keep in mind that Solid H color and Solid V color modes will behave the opposite way in Drill Down Combo Bar PRO, since the series will be displayed starting from the Y axis.

Color modes in Drill Down Visuals conditional formatting

Conclusion

Conditional formatting was a highly requested feature among our users, and we’ve implemented it in Drill Down Combo PRO, Combo Bar PRO, Timeline PRO and TimeSeries PRO visuals. We’ve provided some examples of how to use this handy feature in your reports, but it’s up to you and your creativity to explore its full power!

View all our visuals
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

May 08, 2025

Blog Thumbnail
Guides

Data Literacy: What It Is and Why Every Modern Professional Needs It

Data literacy is no longer optional - it’s essential for success in today’s data-driven world. From marketers to HR professionals, everyone is expected to analyze data, spot trends, and make smart decisions. This article explores what data literacy really means, why it matters, and how to build it across your team and organization.

Apr 30, 2025

Blog Thumbnail
Product updates

April 2025 Update: Multiple Links in Graph PRO & Total Labels for Stacks

Create multiple links between nodes in Graph, enable and customize value labels for stack totals in Combo & Timeline, and more – read about what’s new in ZoomCharts visuals in April!

Mar 28, 2025

Blog Thumbnail
Product updates

March 2025 Update: Show Difference Between Two Values

This month brings multiple new features for better data visualization: change indicator for comparison between two values; on-chart annotations for Waterfall; layout modes for Network, and other improvements. 

Feb 26, 2025

Blog Thumbnail
Product updates

February 2025: What’s New in ZoomCharts Visuals for Power BI

You can now enable extended axis labels in Combo, Combo Bar and Waterfall, assign lasso shapes to specific shape layers in Map, and enter custom display names for link categories in Graph. Read more about the latest update in this article!

Jan 31, 2025

Blog Thumbnail
Guides

Top 12 Key SaaS Business Metrics You Must Track in 2025

ARR, CLV, NRR, churn, and more – learn about the most important SaaS business metrics, their formulas, how to read and interpret them, and how to best visualize them. 

Jan 15, 2025

Blog Thumbnail
Product updates

January 2025: New Customization Options

We have added outline conditional formatting, color customization for selection and highlight areas, comma-separated source nodes for Graph, and a setting to hide empty values in the tooltip.
  • 1
  • 2
  • 3
  • 4
  • 5
  • ...
  • 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