Forum Discussion
Stacked Bar Chart
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.
NathanielThe picture below shows both the selection for Pivot Column and the resulting table.
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
Hi Nathaniel_C , of course, sorry about that. Please see below:
| User | TimerLogDuration | JobType | JobTypeID |
| John Smith | 50 | Billable | 1 |
| Dave Brown | 100 | Non-Billable | 2 |
| Mary Jones | 15 | Billable | 1 |
| John Smith | 150 | Billable | 1 |
| John Smith | 200 | Absent | 3 |
| Sally Wood | 27 | Non-Billable | 2 |
| Frank Walston | 35 | Billable | 1 |
| Sally Wood | 84 | Absent | 3 |
| Frank Walston | 94 | Non-Billable | 2 |
Hi Danbert beat you to it with a dummy table. Let me know if this makes sense.😁
Nathaniel_C, thanks so much for coming back to me so quickly on this. I won't be able to test this until tomorrow but looks exactly like what I'm after. I'll report back tomorrow.
Thanks again.
Nathaniel_C - that worked perfectly, thanks so much that's saved me a lot of time!