Tornado Chart or Alternative

[batranikhil]

Hi,

I'm trying to achieve a tornado chart ( or an laternative) based on multiple columns from a table. Objective is to achieve an output like the following. The value of the bars is the average of each column.:

Sample output 

But the issue is that this is available in different columns in my banner tables. Not able to achieve this using unpivot as well, since it still remains two different column sets in a way. 

Sample Data:

S. No.	Project delivery - Pre-Covid %	Project delivery - Post-Covid %	BD/Sales - Pre-Covid %	BD/Sales - Post-Covid %	GTM - Pre-Covid %	GTM - Post-Covid %	Presentations - Pre-Covid %	Presentations - Post-Covid %	Internal - Pre-Covid %	Internal - Post-Covid %
184	80	20	75	25	70	30	70	30	70	30
684	90	10	70	30	80	20	80	20	80	20
1082	100	0	85	15	80	20	80	20	80	10
1119	90	10	90	10	90	10	90	10	90	10
1171	80	20	40	60	70	30	70	30	70	30
281	85	15	80	20	85	15	85	15	85	15
872	100	0	80	20	90	10	90	10	90	10
919	100	0	80	20	85	15	85	15	85	15
1145	85	15	60	40	80	20	80	20	80	10
156	80	20	75	25	85	15	85	15	85	15
367	90	10	85	15	90	10	90	10	90	10
709	100	0	100	0	95	5	95	5	95	5
816	90	10	85	15	85	15	85	15	85	15
1061	90	10	90	10	80	20	80	20	80	20
1109	80	20	70	30	100	0	100	0	100	0
1178	80	20	85	15	80	20	80	20	80	20
1235	85	15	75	25	60	40	60	40	60	30
1087	75	25	90	10	70	30	70	30	50	30
1128	85	15	85	15	75	25	75	25	50	25
111	75	25	80	20	75	25	75	25	50	25
259	80	20	100	0	100	0	100	0	80	0
343	85	15	70	30	75	25	75	25	75	25
412	70	30	75	25	70	30	70	30	70	30

Looking for some advice. Thanks.

[batranikhil]

Thanks Amit. This really helps. Solved my issue. Cheers.

[amitchandak · Accepted solution]

@batranikhil , Unpivot all columns. Separate outpost covid and pre covid in a new column. Pivot that column again 

Check something similar here if needed

https://kohera.be/power-bi/how-to-unpivot-twice/