Known that it is easy to enhance the difference with clustered chart by choosing option not include zero. However, this option becomes very challenge for stacked charts. The middle charts below are with option “not include zero”, which is very difficult to use. Charts on the right side are requested.
The solution is to turn stacked chart to clustered chart.
- Uncheck option include zero
- Create new column to add both measure together to behave like second measure
- Replace old profit with new measure
- Please note that Bar doesn’t work against this concept.