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
    • Drill Down Line PRO Drill Down Line 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

ZoomCharts Documentation

Up Down
Edit Category
Delete Save Add Child

Use Reference Value

This setting will be available if you have added valid data to the Reference Value field.


If this toggle is disabled, conditional formatting will apply color fill and opacity settings to each shape based on how close its Value is to the minimum and maximum values among all shapes in the layer. Enable this toggle to use the reference value to determine formatting rules of each shape. This will be useful if you need to compare each shape (e.g. country, region or area) against their own benchmarks, KPIs or other metrics.


Enabling this toggle will reveal Reference Value Color and Reference Value Opacity settings which will be applied to shapes that have matching Value and Reference Value. The further the shape’s Value is from its Reference Value, the more its color and opacity will be blended with Min Fill Color and Min Fill Opacity (or Max Fill Color and Max Fill Opacity if it exceeds the reference value).


You can further customize the reference value behavior with the following settings:

  • Value Aggregation: Choose which aggregation method is used for all Values within each shape to determine the value which is used for conditional formatting.
  • Reference Value Aggregation: Choose which aggregation method is used for all Reference Values within each shape to determine the reference value for conditional formatting.
  • Color Scale: Select between relative or absolute scale, which affects the relation between Value and Reference Value when applying conditional formatting.
map-reference-value-conditional-formatting

Was this helpful? Thank you for your feedback!

Sorry about that.

How can we improve it?

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