Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a datset where the entries are by model / serial number. Each entry can have phase 1 and phase 2 builds with associated hours. I'm looking to create a stacked column display for model/serial build time by work week separating colors by the phase of the build. The first image below shows the scheduled time graph I'm building.
The problem I'm running into is that the graph is displaying everything summarized by the phase 1 schedule week. In other words Phase 2 hours are stacking on Phase 1 scheduled work week. How can I get phase 2 hours to show on the correct week? The second graph shows a selection where week 29 is selected, but includes also phase 2 hours for the build where phase 1 is schedule in week 29 (phase 2 is selected). How can i get the 135 hours to show in week 35?
I've tried a number of different sorts, and even separating the build hours into a separate table. I can't seem to separate phase 2 hours.
Thanks in advance!
Solved! Go to Solution.
I solved this by:
I solved this by:
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |