Forum Discussion

plehrman's avatar
plehrman
Frequent Visitor
4 years ago
Solved

Stacked Chart Including Multiple Columns from Smartsheet

Hi,

 

I have a Smartsheet with about 30 columns, all with drop-downs with the same selection values. I would like to create one stacked bar chart that includes counts for each selection in each column. For example:

 

NameColumn 2Column 3Column 4Column 5

Column 6

Joe Schmoe1 - No Experience1 - No Experience3 - Some Experience4 - Very Experience

2 - Little Expereince

Mary Contrary5 - Subject Matter Expert3 - Some Experience4 - Very Experience1 - No Experienc

1 - No Experience

George Kastanza1 - No Experience4 - Very Experience3 - Some Experience5 - Subject Matter Expert

1 - No Experience

 

So, I'd like to create a barchart with each bar representing each column (not [Name]), with the counts of each value in the column.

 

 

I can do this in Excel but I have no idea how to do this with Smartsheets and Power BI.

 

Thanks!

Need Help
  • MFelix's avatar
    MFelix
    4 years ago

    Hi  plehrman ,

     

    On the query Editor select the column name then do the following:

    • Transform
    • Unpivot Columns
    • Unpivot Other Columns

    The final result will be a table with 3 columns:

     

5 Replies

  • plehrman's avatar
    plehrman
    Frequent Visitor
    4 years ago

    Thank you for your response Miguel. I am new to Power BI. How do I unpivot the data?

    • MFelix's avatar
      MFelix
      Super User
      4 years ago

      Hi  plehrman ,

       

      On the query Editor select the column name then do the following:

      • Transform
      • Unpivot Columns
      • Unpivot Other Columns

      The final result will be a table with 3 columns:

       

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    Hi plehrman ,

    Has your problem been solved? If yes, please consider accept it as the solutionto help the other members find it more quickly.

    Best Regards,
    Community Support Team _ kalyj