Bar chart

[PBI_37]

Hi everyone,

I have a dataset with manufacturing steps and durations (there are no start dates) :

I calculated an average.
I would like to create a visual (bar chart, matrix…) in which each step starts at the end of the previous one:

Here the link of PBI file :

https://drive.google.com/file/d/1qmfLjN6hvIxVuNE4Tq9DuDTpg7sPXv-_/view?usp=sharing

Thank you for your help

[MFelix · Accepted solution]

Hi @PBI_37 ,

Add the following measure to your model:

Average empty = 
        SUMX(
            SUMMARIZE(
                FILTER(ALL(Data), Data[Step] < MAX('Dim Step'[Step])),
                'Dim Step'[Step],
                 "Average Total", [Average]),[Average Total])

Now add this measure on your chart has the first value:

Then just make it transparent colour has your background:

[PBI_37]

Thank you @MFelix and @lbendlin .

Your solutions work perfectly.

[lbendlin · Accepted solution]

[MFelix · Accepted solution]

Hi @PBI_37 ,

Add the following measure to your model:

Average empty = 
        SUMX(
            SUMMARIZE(
                FILTER(ALL(Data), Data[Step] < MAX('Dim Step'[Step])),
                'Dim Step'[Step],
                 "Average Total", [Average]),[Average Total])

Now add this measure on your chart has the first value:

Then just make it transparent colour has your background: