My pivot tables have lots of 0.00 values.
PivotTable Option formatting only allow one substitution: For empty cell values show: --
Is there an option to include another substitution: For 0.00 values cells show: --
See the example below where Spaces, Enrolled, Available are all Dax measures.
<tbody>
</tbody>
PivotTable Option formatting only allow one substitution: For empty cell values show: --
Is there an option to include another substitution: For 0.00 values cells show: --
See the example below where Spaces, Enrolled, Available are all Dax measures.
| Spaces | Enrolled | Available | |
| Program | 54 | 1.00 | -53 |
| A | 3 | 0.00 | -3.00 |
| B | 2 | 0.00 | -2.00 |
| C | 6 | 0.00 | -6.00 |
| D | 2 | -- | -2.00 |
| E | 3 | 0.00 | -3.00 |
| F | 7 | 0.00 | -7.00 |
| G | 8 | 0.00 | -8.00 |
| H | 10 | 0.00 | -10.00 |
| I | 5 | 0.00 | -5.00 |
| J | 8 | 1.00 | -7.00 |
<tbody>
</tbody>
