Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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:
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
79 | |
67 | |
60 | |
45 | |
45 |