Forum Discussion

Danbert's avatar
Danbert
Frequent Visitor
6 years ago
Solved

Stacked Bar Chart

Hi   In the below visual, my source data is as it appears in the upper table, but I need to find a way to manipulate the data so it appears like it does in the lower table.   I need to create a s...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Hi Danbert ,

    Dummied up a table for you, you will end up with a table like this by selecting the Type Column and Selecting Pivot on the Transform tab. Use Time as the values.
    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

     







     The picture below shows both the selection for Pivot Column and the resulting table.

     

     

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Hi Danbert ,
Would you copy and paste your first table right into the message so that we can copy and paste it into Power Query? Cannot do that  with pictures.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Hi Danbert ,

Dummied up a table for you, you will end up with a table like this by selecting the Type Column and Selecting Pivot on the Transform tab. Use Time as the values.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 







 The picture below shows both the selection for Pivot Column and the resulting table.