Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Control chart - line chart + scatter + different shapes

I need to produce a control chart as such in Power BI:

Normally I do it by creating 7 different series on top of each other in Excel or other BI tools:

 

  • Upper control limit (top one) - lline series
  • Lower control limit (bottom line) - line series
  • Average (middle line) - line series
  • Value line (black line connecting dots) - line series
  • Blue dots - scatter
  • Red squares - scatter
  • White squares - scatter

Each series will have its own data set with gaps where the series is not supposed to display data.

 

I have not been able to do this in Power BI.  There are limitations with the line series.  The scatter series does not look suitable for this.

 

Any help will be appreciated