Stacked Chart Including Multiple Columns from Smartsheet

[plehrman]

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:

Name	Column 2	Column 3	Column 4	Column 5	Column 6
Joe Schmoe	1 - No Experience	1 - No Experience	3 - Some Experience	4 - Very Experience	2 - Little Expereince
Mary Contrary	5 - Subject Matter Expert	3 - Some Experience	4 - Very Experience	1 - No Experienc	1 - No Experience
George Kastanza	1 - No Experience	4 - Very Experience	3 - Some Experience	5 - 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!

[plehrman]

 Thank you @MFelix! That worked perfectly!

[v-yanjiang-msft]

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

[plehrman]

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

[MFelix · Accepted solution]

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:

[MFelix]

Hi @plehrman ,

The best option is to unpivot the values in order to have it in a format that you can make the chart: