Creating Tornado Chart

Question

Hi,&nbsp;I am trying to create a tornado chart to show a number of different steps that are stored in the same column.&nbsp; The Phases column contains the following 4 values - introduction, discussion, test and review&nbsp;I want to display gender with 3&nbsp;different bars in the tornado chart.&nbsp;&nbsp;The steps are made up&nbsp;of multiple items from the phases columns like the following table.&nbsp;Can anyone advise on how I can best create&nbsp;one&nbsp;column that will show step 1, step2 and step3 which are made up of items from the Phase column so that I can use this in the tornado chart?&nbsp;Step 1Step2Step3IntroductionReviewIntroductionDiscussion&nbsp;TestTest&nbsp;&nbsp;Review&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thanks,Jennifer

v-huizhn-msft · Accepted Answer

Hi&nbsp;Anonymous,Based on&nbsp;my&nbsp;understanding, you want to combine the three steps into one column, right? If it is, you just create a new table by clicking "New Table" under Modeling on Home page, type the following formula.
Table =
FILTER (
    UNION (
        SELECTCOLUMNS ( Table1, "phases", Table1[Step1] ),
        SELECTCOLUMNS ( Table1, "phases", Table1[Step2] ),
        SELECTCOLUMNS ( Table1, "phases", Table1[Step3] )
    ),
    [phases] &lt;&gt; BLANK ()
)

Table1 is the name of your sample table, please review the expected result as follows.Best Regards,Angelia

Forum Discussion

Creating Tornado Chart

2 Replies

Related content

Horizontal Tornado Chart

Tornado Chart with Radically Different Scaled Data

Tornado chart

Creating a Control Chart

Tornado Chart or Alternative

Step 1	Step2	Step3
Introduction	Review	Introduction
Discussion		Test
Test
Review