cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

Hi,

I am trying to create a tornado chart to show a number of different steps that are stored in the same column.  The Phases column contains the following 4 values - introduction, discussion, test and review

I want to display gender with 3 different bars in the tornado chart.  The steps are made up of multiple items from the phases columns like the following table.

Can anyone advise on how I can best create one 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?

 Step 1 Step2 Step3 Introduction Review Introduction Discussion Test Test Review

Thanks,

Jennifer

2 ACCEPTED SOLUTIONS

Accepted Solutions
Microsoft

Hi @jj304,

Based on my 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] <> BLANK ()
)

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

Best Regards,
Angelia

Frequent Visitor

2 REPLIES 2
Microsoft

Hi @jj304,

Based on my 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] <> BLANK ()
)

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

Best Regards,
Angelia

Frequent Visitor

Announcements

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!