Average value per day and the distance between the average per day and the upper and lower control

[Anonymous]

Hello, I have 5 values per day and I want to include a point with the average of the points per day. I would like the average values to connect so you can see the trend over time. I also want to have an option that shows the vertical distance between the average per day and the upper control limit and the lower control limit. The data is below and the progress i have made so far.

original data from excel

Power query information

power bi control chart

[v-janeyg-msft · Accepted solution]

Hello, @Anonymous 

Sorry, after my search and testing, there is no visual that can meet your needs. I think you have to change your mind or implement it in multiple visuals one by one. 

Best Regards

Janey Guo