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
  • Apply Styles
  • Global Style
  • By Level
  1. Filter
  2. Advanced Settings - Introduction

Cell Style

PreviousFilter SettingsNextCell Colors

Last updated 8 months ago

The Cell Style feature in the Filter Advanced settings allows you to customize the appearance of each item in your visual, giving you full control over the font, alignment, and other styling options. Below is a detailed guide to each option available in the Cell Style settings.

Apply Styles

The Apply Styles section offers two main modes for styling your cells:

  1. Global: Applies a uniform style across all levels.

  2. By Level: Customizes styles based on the level of hierarchy.

Global Style

The Global Style option allows you to set a consistent look for all items within your visual. Here's a breakdown of the available options:

Font Size:

Adjust the font size for both the category and the value. You have the option to set individual sizes for each if desired.

Same Text Size for Category & value Checkbox - We can set different sizes for Category and value by unchecking this checkbox

Font Family:

Choose the font family for the category and value. You can select different font families for each to distinguish between them.

Same Font Family for Category & value Checkbox - We can set different Font families for Category and value by unchecking this checkbox

Styling:

  • Bold: Make the text bold for emphasis.

  • Italic: Italicize the text for a stylized appearance.

  • Underline: Underline the text to highlight key information.

Category Alignment:

  • Left: Align the category text to the left.

  • Center: Center the category text within its cell.

  • Right: Align the category text to the right.

Value Alignment:

  • Left: Align the value text to the left.

  • Center: Center the value text within its cell.

  • Right: Align the value text to the right.

Word Wrap:

Enable word wrap to ensure text fits within the cell without being cut off. This is useful for longer text entries. (Checkbox option)

Row Height:

Adjust the row height to fit the content or to provide a more compact or spacious layout.

Dividers:

Add dividers between rows to visually separate them. You can customize:

  • Size: Set the thickness of the dividers.

  • Color: Choose a color for the dividers.

Only For Parent Level: Option to apply dividers only to parent-level items, distinguishing them from child-level entries. (Checkbox option)

Example -

By Level

The By Level option offers advanced customization, allowing you to set different styles for each level of hierarchy. This is particularly useful when you want to differentiate between parent and child levels.

Font Size:

As with the global setting, you can set individual font sizes for categories and values at each hierarchy level.

Font Family:

Choose a font family specific to each level, providing the visual distinction between different levels.

Styling:

  • Bold: Apply bold styling to make certain levels stand out.

  • Italic: Italicize text at certain levels for differentiation.

  • Underline: Underline text for emphasis at specific levels.

Category Alignment:

  • Left: Align the category text to the left.

  • Center: Center the category text within its cell.

  • Right: Align the category text to the right.

Value Alignment:

  • Left: Align the value text to the left.

  • Center: Center the value text within its cell.

  • Right: Align the value text to the right.

Word Wrap:

Enable word wrap to ensure text fits within the cell without being cut off. This is useful for longer text entries. (Checkbox option)

Row Height:

Adjust the row height to fit the content or to provide a more compact or spacious layout.

Dividers:

Add dividers between rows to visually separate them. You can customize:

  • Size: Set the thickness of the dividers.

  • Color: Choose a color for the dividers.

Example -