Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Creating funnel charts from awkward data

Hi   I have a problem from the world of British Further Eduction(FE):   I've demonstrated how Funnel Charts could be useful in FE, from this sample data I created:   Giving a funnel chart...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    8 years ago

    Hi Anonymous

     

    You may try to use 'Unpivot Only Selected Columns' in Query Editor as below. Then create relationships for the 3 sheets. Last, you may create measure or drag the columns to Funnel Visual as requested.

     

    Regards,

    Cherie

     

     

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous

 

You may try to use 'Unpivot Only Selected Columns' in Query Editor as below. Then create relationships for the 3 sheets. Last, you may create measure or drag the columns to Funnel Visual as requested.

 

Regards,

Cherie

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you Cherie - easy when you know how, I've used my data to produce the following Funel Diagram: