Hello,
I am trying to make a Tornado chart with the imported visual (Microsoft).
I have one column and two calculated measures. No of purchases (Column), No of Purchase Same Period Last Year (Measure) and Chage from SPLY (Measure). I would like to add a measure to show a categorical value (increase or decrease) based on the Change from the SPLY measure. So I would like to make a dynamic calculated table like below (Increase or Decrease changes dynamically). Would it be possible, please?
| Customer Name | Case rate per 1k MSOA | No of purchases | No of purchases SPLY | Change from SPLY | Increase or Decrease |
| Adam | | 282 | 258 | 24 | Increase |
| Amber | | 849 | 824 | 25 | Increase |
| Andy | | 1244 | 1244 | 0 | |
| Abby | | 1268 | 1244 | 24 | Increase |
| Ben | | 853 | 831 | 22 | Increase |
| Chaire | | 691 | 688 | 3 | Increase |
| Charles | | 684 | 713 | -29 | decrease |
| Fred | | 699 | 726 | -27 | decrease |
| Emma | | 485 | 522 | -37 | decrease |
| Emily | | 818 | 892 | -74 | decrease |
| Nathan | | 732 | 816 | -84 | decrease |
| Helen | | 760 | 843 | -83 | decrease |
| Debra | | 1628 | 2000 | -372 | decrease |
| Hazel | | 844 | 988 | -144 | decrease |
| Laura | | 1043 | 1130 | -87 | decrease |
| Stephen | | 707 | 798 | -91 | decrease |
| Denise | | 321 | 363 | -42 | decrease |
| Debbie | | 557 | 611 | -54 | decrease |
| Richard | | 847 | 999 | -152 | decrease |
| Maria | | 871 | 981 | -110 | decrease |
| Colin | | 419 | 482 | -63 | decrease |
| David | | 914 | 1051 | -137 | decrease |
I just noticed increase was 0 value, what can I do for the Tornado chart?
Thanks for your help.
Toshie
