Inforiver Videos
MatrixEnterprise
  • Writeback Matrix
    • Overview
      • Enterprise Planning & Performance Management in Power BI
      • Real-Integrated Planning in Power BI
      • Top 5 Driver-Based Planning Techniques in Power BI
      • Power BI Writeback - A deep dive
    • Features
      • Summary
      • Collaborative commenting
      • Schedule, burst & broadcast reports
      • Data writeback
      • Writeback to Fabric OneLake/Data Warehouse
      • Ad-hoc emails
      • Dropdown lists
  • Reporting Matrix
    • Expert speak
      • Visual formulas vs DAX with Marco Russo
      • Faster reporting and insights with Matt Allington
      • The best custom visual for Power BI?
      • Build a P&L / Income statement in less than 5 minutes
      • Formatting financial statements in Power BI - P&L
    • Overview
      • No-code reporting
      • Cutting-edge data visualizations
      • Advanced data analysis
      • Data provenance & audit
      • What-if simulations
    • General
      • Reorder rows and columns
      • Layout options
      • Advanced filtering
      • Nested top N + others
      • Conditional formatting
      • Number formatting
      • Cell & value formatting
      • Notes & annotations
      • Comments with filter context
      • Totals & subtotals
      • One-click templates
      • Pagination
      • Group rows and columns
      • Search & filter
      • Expand/collapse hierarchy
      • KPI explorer
      • Audit log
      • Export to Excel
      • Comparative measures
      • Images in columns
      • Ragged hierarchies
    • Formula & calculations
      • Excel-like cell editing
      • Insert calculated and static rows
      • Insert calculated column
      • Insert calculated measure
      • Quick formula options
      • Invert signs
    • Planning, budgeting & forecasting
      • Manual data input
      • Allocations
      • What-if simulations
      • Data entry & simulations in reading view
      • No-code rolling forecasts
    • Graphical tables
      • IBCS visualizations
      • Bar charts
      • Lollipop charts
      • Waterfall charts
      • Bullet charts for 2 measures
      • Bullet charts for 3 measures
      • Stacked charts
      • Sparkline charts
      • Tornado charts
      • KPI cards
      • Blend column
    • Conditional formatting
      • One-click options
      • Semantic formatting
      • Heat map formatting
      • Format entire row
      • Traffic light & arrow alert
      • Fill icon and star rating
      • Segmentation
      • Format top/bottom N rows
      • Branch level formatting
      • Conditional formatting of multiple hierarchies
      • Dynamic conditional formatting
      • Format using if conditions
    • Visual-level formulas
      • Excel-like cell editing
      • Quick formula options
      • Smart analysis
      • Excel-like formula editor
      • Calculated measures and columns
      • 4 ways of inserting rows
      • Evaluate columns before rows
      • Manage aggregations
      • Automatic variance calculations
  • Analytics+
Powered by GitBook
On this page
  1. Reporting Matrix

Conditional formatting

PreviousBlend columnNextOne-click options

Last updated 2 years ago

(05:33)

Highlight specific performance areas using one-click options such as quick rule, color scales, classifications, and data bars

(01:13)

Format positive and negative numbers using colors and indicate negative values with "-" or "()"

(02:29)

Apply color scales such as sequential, qualitative, diverging in a single-click

(01:56)

Apply formatting to entire rows or row headers, based on your requirements

(02:40)

Apply traffic light icons based on predefined ranges and customize icons/colors

(01:48)

Highlights values with circle fill and star rating icons based on ranges, with custom options

(02:27)

Perform analysis such as ABC analysis and create segments based on text, ratings or icon sets

(01:19)

Highlight top/bottom performers in reports with Inforiver's customizable conditional formatting

(03:16)

Apply different conditional formatting rules to different branches in a hierarchy

(01:39)

Learn to highlight different levels in a hierarchy based on rules without affecting totals

(01:59)

Highlight cells based on a dynamic cell selection

(02:33)

Easily apply conditional formatting based on IF conditions

One-click options
Semantic formatting
Heat map formatting
Format entire row
Traffic light & arrow alert
Fill icon and star rating
Segmentation
Format top/bottom N rows
Branch level formatting
Conditional formatting of multiple hierarchies
Dynamic conditional formatting
Format using if conditions