Forum Discussion

PBI_37's avatar
PBI_37
Helper I
1 year ago
Solved

Bar chart

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 ea...
Need Help
  • MFelix's avatar
    MFelix
    1 year ago

    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: