Forum Discussion

rcardozo's avatar
rcardozo
Regular Visitor
9 years ago
Solved

Pie Chart Data

Hi Is there a way that i can present my data so it  has the categories as the legend, and totals agree/Strongly agree in the pie graph?
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    rcardozo

     

    First, you need to transform your data:

     

    Go to Edit Query, Select all the columns and Go to Transform - Unpivot Columns

     

    Change the name of columns like you want. 

    Close & Apply

     

    Create a Chart

     

    Legend-Answer

    Details-Type

    Values-Count of Answer

     

    Other alternative Chart

     

    Legend-Type

    Details-Answer

    Values-Count of Answer

     

     

  • Vvelarde's avatar
    Vvelarde
    9 years ago

    To Sort the Answer, create a conditional column (Edit Query) :

     

    If Answer is

    Agree 1

    Strongly Agree 2

    Disagree 3

    Strongly Disagree 4

     

     

    Close & Apply

     

    Select the column Answer in your fields panel and go to modeling Sort By Column: Thenameofyourconditionalcolumn

     

rcardozo's avatar
rcardozo
Regular Visitor
9 years ago

Hi Guys,


Thanks for all your help so far. I think i'm almost there.

 

Not sure if i am doing something wrong or missing a step, but this is the chart that I get:

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi rcardozo,

In the Pie Chart, the different colour sectors(like the Red, Yellow, Green, Black) display there are four dategoreis in your Answer field. For each sector, there are multiple sub-sectors based on your Type field. If the result is what you want?

Best Regards,
Angelia