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
  • Ranking
  • Sort
  • Legends
  • Axis
  • Gridlines
  • Data Labels
  • Number Formatting
  • Global Options
  1. KPI
  2. Edit Mode - Introduction
  3. KPI Charts

Format Tab

Last updated 3 months ago

Ranking

  • Ranking Toggle: Enable or disable ranking.

  • Ranking: Specify whether to rank Top or Bottom values.

  • Ranking Count: Define the number of ranked items.

  • Ranking By: Select the field used for ranking.

Sort

  • Default: Use the default sort order.

  • Ascending: Sort in ascending order by the selected field.

  • Descending: Sort in descending order by the selected field.

Legends

  • Legends Toggle: Enable or disable legends.

  • Position: Choose the legend position (e.g., Bottom Left, Top Center, etc.).

  • Size: Adjust the legend size.

  • Color: Set the legend text color.

Axis

Y-Axis

  • Toggle On/Off: Show or hide the Y-axis.

  • Title Checkbox: Enable or disable the axis title.

  • Labels Toggle: Show or hide Y-axis labels.

  • Size: Adjust the font size for labels.

  • Color: Define the label color.

X-Axis

  • Toggle On/Off: Show or hide the X-axis.

  • Title Checkbox: Enable or disable the axis title.

  • Labels Toggle: Show or hide X-axis labels.

  • Size: Adjust the font size for labels.

  • Color: Set the label color.

  • Auto X-Axis Value: Automatically adjust the axis scale.

Gridlines

Y-Axis

  • Toggle On/Off: Enable or disable Y-axis gridlines.

  • Line Style: Choose from various line styles (e.g., Solid, Dash, Dot).

  • Width: Adjust the gridline thickness.

  • Color: Set the gridline color.

X-Axis

  • Toggle On/Off: Enable or disable X-axis gridlines.

  • Line Style: Choose from various line styles (e.g., Solid, Dash, Dot).

  • Width: Adjust the gridline thickness.

  • Color: Define the gridline color.

Data Labels

The Data Labels section provides customization options for displaying and styling data labels on the chart, ensuring clear and meaningful representation of data values. Below are the available settings:


Size

Adjust the size of the data labels to suit your chart design and improve readability.


Position

Determine where the data labels appear on the chart:

  • Auto: Automatically decides the optimal position for labels.

  • Inside End: Places the labels inside the bar at the end.

  • Outside End: Positions the labels outside the bar at the end.

  • Inside Center: Centers the labels inside the bar.


Auto Color Toggle

Enable this option to automatically adjust the label color for better visibility against varying bar colors.


Styling

Customize the appearance of the data labels with the following formatting options:

  • Bold: Apply bold text formatting.

  • Italic: Add italicized styling for a refined look.

  • Underline: Underline the text for emphasis.


Hide "0"/Null Values

Hide data labels for values that are "0" or null to maintain a clean and uncluttered chart.

Number Formatting

  • Display Unit: Select the unit for displaying values (e.g., Thousand, Million, etc.).

  • Prefix: Add a prefix to the displayed values.

  • Suffix: Add a suffix to the displayed values.

  • Decimals: Set the number of decimal places.

  • +Format: Choose between 123 or +123 for positive values.

  • -Format: Choose between -123 or (123) for negative values.

  • Percentage Checkbox: Display values as percentages.

  • Comma Checkbox: Add commas to separate large numbers.

  • Hide Null Values Checkbox: Enable or disable the display of null values.

  • Display Null Values As: Choose to display null values as Zero, Null, or Blank.

Global Options

  • Font Family: Select a font family for text elements.

  • Styling (B/I/U): Apply Bold, Italic, or Underline styling.

  • Show Tooltip: Enable or disable tooltips on hover.