...
Conditional formatting is available in Style Set data section. It appears for Simple table and measures in Pivot table chart. Please note, that it is not available for the rest of charts.
Please note that currently Styles conditional formattings are applied only to in app view. If you export the table, styles will not be applied to the cells.
...
To customize the look of your table, please add a conditional formatting by expanding Style a measure in Set data section and clicking on “+ Add a condition”. You will see settings for a new condition.
First, please select Field. Styles will be applied to chosen fieldmeasure, if condition criteria is met.
...
Please note, that it is only possible to add a field for building condition only if that field is added in Set data as a Row, Column or Measure.
...
.
Below you will see Condition selector. Please select one of available condition for the chosen field.
Depending on field type, list of conditions can be different.
...
| Info |
|---|
Please note that if there are some conditions that overwrite each other, last added condition will be applied. |
| Info |
Please note, that if you switch from Pivot table to Simple table chart or vice versa in Set chart, condition list will be adjusted. By switching from Pivot table to Simple table the only conditions will be kept that are based on fields added as columns. Rows and measures based conditions will be removed. If you switch from Simple table to Pivot table, conditions will be moved, if new pivot table contains the same columns as previous Simple table. |
Edit a condition
To edit a condition, please kindly expand it clicking on arrow icon in the measure.
You can edit any field or condition parameters. Changes will be applied automatically.
...