Forum Discussion
Create Cummulative Measue for stack Chart
Hi @sharmavick,
Thank you for reaching out to the Microsoft Fabric Community Forum.
As per your request, you would like to display the Step ID on the axis instead of the Step Number.
Could you please confirm if the implementation meets your requirements, as shown in the attached image?
Additionally, I have included the PBIX file that I created using the provided sample data. Kindly review it and confirm whether it aligns with your expectations.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you.
Hi sharmavicky
Can you please post a sample data and your expected result from that? You may also post a sanitized copy of your pbix. A link to the file in the cloud will do.
Hi danextian
Here is the sample data Here Product is slicer with single select,
I want to create stack chart using Step_ID, Step Number on Y Axis and Duration on x axis in way please check image for the same
| Product | Step_ID | Step Number | Actual_Duration |
| 1 | Assembly Step 1 | 1 | 24 |
| 1 | Assembly Step 2 | 2 | 28 |
| 1 | Quality Check 1 | 3 | 31 |
| 1 | Packaging Step 1 | 4 | 15 |
| 1 | Delivery Prep | 5 | 18 |
| 1 | Final Inspection | 6 | 12 |
| 1 | Wrapping | 7 | 18 |
| 1 | Sealing | 8 | 9 |
| 1 | Storage Prep | 9 | 19 |
| 1 | Loading | 10 | 32 |
| 1 | Dispatch Ready | 11 | 14 |
I know this can be acehieved by creating cummlatove measure which i am able in my question you cna see that. Challenge is I want to show Step ID on my axis instead of step number.
Hope this helps