Create Cummulative Measue for stack Chart

[sharmavicky]

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 

[renyusen]

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)

[v-tsaipranay · Accepted solution]

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.

[v-tsaipranay]

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.

[v-tsaipranay]

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.

[v-tsaipranay]

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.

[danextian]

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]

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