Last Modified Date: 19 Nov 2017
- Drag measure with negative and positive values onto Columns.
- For example, using the SuperStore sample data, use the Profit measure.
- Drag dimension at which you want to see split onto the Rows.
- For example, using the SuperStore sample data, use the Segment & State dimensions.
The above example can be reviewed in the attached workbook: Diverging Bar Chart.twbx.
Additional InformationTypically if you do not see both negative and positive values, this is because the level of detail is too high and the overall aggregation will be one or the other.
For example, in the attached workbook State is on the view but if that is removed then we only see positive profit overall. If there is negative and positive values in the data and you want to see this displayed, then add a field to the view with enough granularity to show this spread.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials