Blazor Pivot Table Example - Conditional Formatting

This sample demonstrates conditional formatting functionality for customizing pivot table cell appearance based on user-defined conditions.

The conditional formatting dialog enables adding conditions and styles dynamically. Formatting can be added, removed, and reset at runtime.

Conditional formatting features:

• Apply to cells with values only
• Customize background color, font color, font family, and font size
• Configure through UI dialog or code-behind
• Enable via AllowConditionalFormatting property
• Access UI via ShowConditionalFormattingDialogAsync method

Configuration properties in PivotViewConditionalFormatSetting:

• Measure - Value field name for style application
• Condition - Operator type (equals, greater than, less than, etc.)
• Value1 - Start value for filtering
• Value2 - End value (for range conditions)
• Style - Cell appearance customization
• ApplyGrandTotals - Apply to row/column grand totals

The Reset All option clears all applied conditional formatting.

For comprehensive documentation, refer to the documentation.