Forum Discussion
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 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
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:
3 Replies
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:
