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 Bokazoit, Vvelardev-huizhn-msft

 

Thanks for all your help. I think i've figured it out.

 

I've now presented the data into a stacked bar graph. i just havent figured out how to change the order of the legend, but i'm pretty happy with the result.

 

Thanks again for everyone's help!

 

Vvelarde's avatar
Vvelarde
Community Champion
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

    Thanks so much Victor!

     

    This works perfectly! :)