logo
For Power BI
  • Products
    • Custom Visuals for Power BI
    • Report Templates
  • 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
    Get Developer License
  • Services
    • Power BI Report Development
    • Custom Visual Development
  • Challenges
  • Pricing
    • Custom Visuals for Power BI
    • Report Templates
Request a quote Get Developer License Sign in
Request a quote Book a Demo Get Developer License 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

© 2026, Data Visualization Software Lab

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

Cookies
Privacy Policy
Global
Legal
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.