Powerviz
  • Introduction
  • Installation Guide
    • Install from Appsource
    • Import through file
    • Adding the Powerviz visuals as Organization visuals
  • Date Picker
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings: Introduction
      • Calendar
      • Formatting
      • Date Picker Button
      • Default Selection
      • Date Selector
      • Presets
      • Selection Controls
      • Date Range
      • Invalid Dates
      • Weekends/Holidays
    • Themes
      • Default Theme
      • Custom Theme
  • Sunburst
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings: Introduction
      • Chart Options
      • Data Colors
      • Fill Patterns
      • Arc Settings
      • Labels
      • Sorting
      • Ranking
      • Center Circle
      • Leaf Label Images
      • Conditional Formatting
      • Show Condition
      • Annotations
      • Grid View
    • FAQ
  • KPI
    • Introduction
    • Get Started
    • Format Pane
    • Edit Mode - Introduction
      • KPI Charts
        • Advanced Text
        • Bar Chart
        • Lollipop Chart
        • Line Chart
        • Area Chart
        • Combo Chart
        • Donut Chart
        • Pie Chart
        • Linear Gauge
        • Liquid Gauge
        • Radial Gauge
        • Bullet Chart
        • Waterfall Chart
        • Icon
        • Image
        • Shape
      • Templates
      • Small Multiples
      • Actions
      • Import/Export
  • Activity Gauge
    • Introduction
    • Get Started
    • Format Pane
    • Advance settings: Introduction
      • Gauge Options
      • Target
      • Data Colors
      • Fill Patterns
      • Labels
      • Ranking
      • Sorting
      • Center Circle
      • Mouse Over Text
      • Conditional Formatting
      • Show Condition
      • Grid View
      • Annotations
  • Funnel Chart
    • Introduction
  • Horizon Chart
    • Introduction
  • Ridgeline Plot
    • Introduction
  • Rose/ Donut/Pie Chart
    • Introduction
  • Word Cloud
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings: Introduction
      • Word Options
      • Data Colors
      • Shapes
      • Text Style
      • Direction
      • Ranking
      • Exclude
      • Conditional Formatting
      • Show Condition
      • Grid View
      • Lasso and Reverse Lasso
  • Linear Gauge
    • Introduction
  • Filter
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings - Introduction
      • Filter Settings
      • Cell Style
      • Cell Colors
      • Title Bar
      • Column Headers
      • Image Styling
      • Default Selection
      • Conditional Formatting
      • Import/Export
      • Templates
  • Lollipop Chart
    • Introduction
  • Heatmap
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings: Introduction
      • Shapes
      • Data Colors
      • Data Labels
      • Axis Settings
      • Grid Lines
      • Sorting
      • Plot Area
      • Reference Lines
      • Ranking
      • Totals
      • Small Multiples
      • Conditional Formatting
      • Show Condition
      • Grid view
      • Lasso and Reverse Lasso
  • Network Graph
    • Introduction
  • Sankey Chart
    • Introduction
Powered by GitBook
On this page
  • Inputs for Single Rule Type
  • Inputs for Compare Rule Type
  1. KPI
  2. Edit Mode - Introduction
  3. KPI Charts

Conditional formatting

Last updated 3 months ago

Inputs for Single Rule Type

Value Field

Select a field from the available data to evaluate.

Aggregation

Choose how the data will be summarized:

  • None

  • Sum

  • Average

  • Min

  • Max

  • First

  • Last

Comparator

Specify the comparison condition:

  • Equal To

  • Not Equal To

  • Less Than

  • Greater Than

  • Less Than Or Equal To

  • Greater Than Or Equal To

  • In Range

  • Not In Range

Value Type

Define how values are entered:

  • Fixed

  • Type Field

Value/Field

Enter the value or select a field for comparison.

Color

Set the color to apply when the rule conditions are met.


Inputs for Compare Rule Type

  • Value Field: Select a data field to evaluate.

  • Condition: Choose from the following comparison methods:

Compare first value with next value

Evaluate the difference between the first data point and the next one in the dataset.

Compare first value with fixed value

Check how the first data point compares to a constant value.

Compare first value with target value

Determine if the first data point aligns with a target value.

Compare first value with last value

Measure changes from the first to the final data point.

Compare last value with fixed value

Compare the last data point to a constant value.

Compare last value with target value

Check if the last data point meets a target value.

Compare last value with first value

Identify trends by comparing the last and first data points.

Compare last value with previous value

Examine differences between the last and previous data points.

Compare max value with fixed value

See how the highest value compares to a constant.

Compare max value with target value

Assess whether the maximum value aligns with a target.

Compare average value with fixed value

Compare the average of the dataset to a fixed benchmark.

Compare average value with target value

Evaluate the dataset’s mean against a target.

Compare total value with fixed value

Match the dataset’s total to a fixed value.

Compare total value with target value

Check if the dataset’s total meets a specified target.

  • Target Field/By Category/Value Field: Specify the target or category for comparison.

  • Sort Order: Select the sorting method:

    • Ascending

    • Descending

  • Condition:

    • More is better

    • Less is better

  • Colors:

    • Good

    • Neutral

    • Bad