This panel is available only if you have added a tabular view to the analysis using the "BI Composer wizard -- Create Analysis: Select Views panel."
Use this panel of the "BI Composer wizard" to:
Apply conditional formatting to measure columns in tabular views. Conditional formatting helps direct attention to a data element if it meets a certain condition. For example, you can show below-quota sales figures in a certain color.
(You cannot apply conditional formatting to attribute or hierarchical columns.)
Preview the results.
For more information, see:
This panel is also displayed as:
Components
Expand Formatting or Collapse Formatting
Use this button to expand or collapse the Formatting area.
Formatting
Use this area to specify and manage conditional formatting on columns. It contains the follow components:
Add Column Format — Use this button to select the column to which to apply conditional formatting and to add a formatting entry to the Formatting table.
Formatting Table — Displays an entry for each column to which conditional formatting is to be applied. You manage each entry as follows:
To enter the values for the threshold that divide each formatting range, use the threshold fields.
For example, suppose that you are working with the # of Orders column, and you want orders that fall below 5000 highlighted in red, orders between 5000 and 8000 highlighted in yellow, and orders over 8000 highlighted in green. To do so, in the first threshold field, you enter 5000, and in the second threshold field you enter 8000.
To select the color to represent each formatting range, click the down arrow to the right side of the Color box to display the color dialog.
To delete an entry, click Delete.
Preview
Use this box to specify whether to display a preview of the results:
Select this box to display a preview of the actual analysis and data.
Note: Selecting this box might impact performance if the query for data results in very large data sets. |
Deselect this box to display an image that represents each view in the analysis.
Show how results will look on a dashboard
Use this button to show a fully interactive view where you can page through large result sets, drill, and so on.
Report XML
Use this button to show the XML code for the analysis. This information is helpful for debugging purposes.