Forum Discussion

sharmavicky's avatar
sharmavicky
New Member
1 year ago
Solved

Create Cummulative Measue for stack Chart

Hi Everyone, 

 

I am creating a stack chart where i have one measure in intend to create a gannt chart using stack chart.

 

I have the following column 
1. Unique ID is on slicer with single select

2. Step ID (Name of Step)

3. Step Number (sequence of the corresponding step

4. Actual Duration

 

And i am using this measure to create my cummulative 

Cumulative Duration =
var cumulativesum = CALCULATE(
    SUM('fact_table'[Actual_Duration]),
    FILTER(
        ALLSELECTED('fact_table'[Step Number ]),
        'fact_table'[Step Number ] <= MAX('fact_table'[Step Number ])
    )
)
return cumulativesum - fact_table[Actual Average Duration]
 
this some how works correclty but what i want is for given Step Number & Step ID i want to create this cumulative 
 

But when i am going step_id 

 

So i want to sort by Step Number and i have step ID as well by using expand drill down the order should be there so that my gannt chart will be correct 

 

Any suggtation will help to achive this gannt chart in correct sort order 

Note: I cannot use Gannt Chart here due to certain limitation

@

Thanks in Advance 



 

 

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

7 Replies

  • danextian's avatar
    danextian
    Super User
    1 year ago

    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.

    • sharmavicky's avatar
      sharmavicky
      New Member
      1 year ago

      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 

      ProductStep_IDStep NumberActual_Duration
      1Assembly Step 1124
      1Assembly Step 2228
      1Quality Check 1331
      1Packaging Step 1415
      1Delivery Prep518
      1Final Inspection612
      1Wrapping718
      1Sealing89
      1Storage Prep919
      1Loading1032
      1Dispatch Ready1114

       

      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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi sharmavicky 

      May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

      Thank you.

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi sharmavicky,

        I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.


        Thank you.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi sharmavicky,

       

      I wanted to follow up on our previous suggestions regarding creating a Gantt chart using a stacked chart. We would love to hear back from you to ensure we can assist you further.

      If my response has addressed your query, please 'accept it as a solution' and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

       

      Thankyou.

  • renyusen's avatar
    renyusen
    Frequent Visitor
    1 year ago

    try this:

    add a constant value column as the first stack column,  whose label is bind with the step_ID,  then  use the label as the new Y,  disable the former  Y lable ( stemp number)