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 col...
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:

     

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: