Highlight in Table based on another column

Highlight in Table based on another column

The Highlight is configured with condition based on constant or another column in the configuration.

The Highlight based on another column configuration is done as below:

The chart data before adding highlight condition is displayed as below for Table, sparkline, Cross Table charts.

The table and sparkline charts are configured with Highlight condition with condition based on Column configuration:

The charts after this formatting are displayed as:

The values in Location column are Highlighted based on the added condition comparing data in Location_Pune column.

For cross table chart, the highlight conditions are applied as below:

This results chart data with Highlighted values in the columns.


    • Related Articles

    • Highlight in Table

      The Highlight option is used for the conditional formatting of a widget. You can change the look and feel of the widget based on conditions that are configured. The conditional formatting explained here highlights various data values present in table ...
    • Highlight

      The Highlight option is used for conditional formatting of the chart. You can change the look and feel of the chart based on conditions that you can configure. This option is available for Line Chart, Bar Chart, Column Chart, Solid Guage Chart, Pie ...
    • Highlight- Configure Retain Table Style

      The option Retain Table Style, is available to configure highlight with table style retained. This option is available in Highlight configuration for Table, Sparkline and Cross Table. For Cross Table the highlight configuration done as below: The ...
    • Highlight- Hide Values Support

      The option Hide Values, is available to configure highlighting with or without showing data values. This option is available in Highlight configuration for Table, Sparkline and Cross Table. When data values are hidden, the Style Icon is shown or ...
    • Column

      The column formatting option is available in widgets that contain Tables. The table given below describes different fields present on Column formatting. Field Description Remark Header Font Font of the Header row — Background Color It allows you to ...