Conditional formatting allows you to see the distribution of your data and highlight
exceptional data points by using color in your table or crosstab visualizations. For example, you
might want to highlight low sales numbers in red, or use green to highlight sales numbers over a
certain threshold.
Procedure
-
Open a table or crosstab visualization.
-
Drag the measure that you want to highlight to the Color data
slot.
-
Close the visualization.
-
To edit the conditional formatting, tap the visualization, then tap .
Use the sliders at the bottom of the visualization.
- You can add a handle to add another color category. You can display up to five color categories
on your slider. To add a handle, tap the canvas under the slider close to where you want the new
handle to appear.
- You can manually expand the range of values on the slider. Tap the first or last handle on the slider and drag it outside the current range. The values on the slider will
increase.
- You can remove a handle from the slider. To do so, right-click the handle and tap the Delete
icon.
-
To use a different color palette, or to change the order of the colors on the palette, select
the visualization, tap the Properties icon and then tap the
Details tab.