Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |