Forum Discussion
conditional formatting based on each column
Select the Table or Matrix Visual: Click on the table or matrix visual where you want to apply the conditional formatting.
Open Conditional Formatting: Go to the "Format" pane, expand the "Conditional formatting" section, and select the field you want to format.
Choose Background Color: Click on the "Background color" option.
Format by Field Value: In the conditional formatting settings, choose "Format by" and select "Field value".
Select the Field: Choose the field that contains the values you want to use for the color gradient. This should be the same field that is used in the column you are formatting.
Apply to Each Column Separately: Repeat the above steps for each column you want to format separately. This way, each column will have its own color gradient based on its own values.
Select the Table or Matrix Visual: Click on the table or matrix visual where you want to apply the conditional formatting.
Open Conditional Formatting: Go to the "Format" pane, expand the "Conditional formatting" section, and select the field you want to format.
Choose Background Color: Click on the "Background color" option.
Format by Field Value: In the conditional formatting settings, choose "Format by" and select "Field value".
Select the Field: Choose the field that contains the values you want to use for the color gradient. This should be the same field that is used in the column you are formatting.
Apply to Each Column Separately: Repeat the above steps for each column you want to format separately. This way, each column will have its own color gradient based on its own values.